Formatting a locked worksheet column

S

Spichael

Board Regular
Joined
Mar 18, 2002
Messages
73
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.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
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
 
Upvote 0
I have tried that and it still gives me the error "Unable to set NumberFormat property of the Range Class".
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Locking Worksheet
Replies
3
Views
123
dmt32
D
sparky2205
  • Question
Maintain formats while copying rows in protected sheet
Replies
0
Views
303
sparky2205
sparky2205
H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
252
hcgood
H
P
  • Question
Lock cells when text entered into another vba not working
Replies
0
Views
390
P4444
P
A
  • Question
Excel table protection with formula copying
Replies
2
Views
538
Allie_Excel
A

Forum statistics

Threads
1,214,599
Messages
6,120,447
Members
448,966
Latest member
DannyC96

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top