Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 17th, 2004, 08:24 PM
Registered User
 
Join Date: Mar 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unprotect a cell on Excel

Hi all,

I am new here.
I need unprotect a worksheet on Excel:
I have an old timeheet from my old work, I need to use it again, so I need to change some info, and always shows up this:

!The cell or chart you are trying to change is protected and therefore read-only.

To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password.

The deal it is I do not remeber that deam password

Some ideas, I do really need help, I am so stupid for programing and do thinks on a PC.

Thanks a ton in advance

  #2 (permalink)  
Old April 7th, 2004, 10:43 PM
Registered User
 
Join Date: Mar 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

PLEASE HELP, I really need some help!!
I do really apreeciate if some body can help me with that.
please help!!!

  #3 (permalink)  
Old April 14th, 2004, 11:26 AM
Registered User
 
Join Date: Apr 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Chk out if this site would be of help to you...
http://forums.devshed.com/showthread...454#post555454

Once the password is known, you can unprotect few cells on the Excel sheet by selecting the range of the cells and then "Format cells->Protection->Uncheck Locked.

- Sham








Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cell Formating Using C# veeruu C# 5 September 21st, 2011 01:56 PM
Protect / Unprotect Excel 97 - VBA Code - jlpazv Excel VBA 2 November 30th, 2007 10:54 AM
c# and Excel cell values hardboiled C# 0 November 16th, 2007 11:12 AM
unprotect excel in vbscript emmydotnet VBScript 5 March 12th, 2007 02:50 PM
cell colouring EXCEL crmpicco Excel VBA 2 April 20th, 2005 11:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.