Formatting a locked worksheet column

Spichael · Mar 19th, 2002, 09:13 AM

I have a locked worksheet. One of the columns needs formatted to Number "0.000".
I keep getting an error message. The only way it'll let me perform the action is to unlock the sheet which opens it up to corruption. I would appreciate any VB code.

Audiojoe · Mar 19th, 2002, 09:16 AM

Could you maybe just unlock that one cell? Or do you need the entire sheet to be locked?

If you can leave that one cell unlocked, you could unprotect the worksheet, right click on the cell, go to Format Cell, click the Protection tab and uncheck the Locked tick box. Now come out and protect the sheet as usual. That cell will stay unlocked and the rest of the sheet will be protected

Spichael · Mar 19th, 2002, 09:27 AM

I have tried that and it still gives me the error "Unable to set NumberFormat property of the Range Class".

NateO · Mar 19th, 2002, 09:31 AM

The following post has code for locking and unlocking worksheets:

http://www.mrexcel.com/board/viewtop...c=2225&forum=2

Mar 19th, 2002, 09:31 AM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	The following post has code for locking and unlocking worksheets: http://www.mrexcel.com/board/viewtop...c=2225&forum=2 __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 09:13 AM	#1
Spichael Board Regular Join Date: Mar 2002 Posts: 69	I have a locked worksheet. One of the columns needs formatted to Number "0.000". I keep getting an error message. The only way it'll let me perform the action is to unlock the sheet which opens it up to corruption. I would appreciate any VB code.

Mar 19th, 2002, 09:16 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Could you maybe just unlock that one cell? Or do you need the entire sheet to be locked? If you can leave that one cell unlocked, you could unprotect the worksheet, right click on the cell, go to Format Cell, click the Protection tab and uncheck the Locked tick box. Now come out and protect the sheet as usual. That cell will stay unlocked and the rest of the sheet will be protected

Mar 19th, 2002, 09:27 AM	#3
Spichael Board Regular Join Date: Mar 2002 Posts: 69	I have tried that and it still gives me the error "Unable to set NumberFormat property of the Range Class".