Formatting a locked worksheet column
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formatting a locked worksheet column

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    The following post has code for locking and unlocking worksheets:

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com