LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maurice
 
Posts: n/a
Default Bug in Worksheet protection?

I've made a worksheet (Excel 2003) that I have protected. Most cells are
locked, only some are accessible to the people making use of it. I've set the
Worksheet protections (Tools - Protection - Protect Sheet) to only allow
selection of unlocked cells, locked cells should not be selectable.

However, after saving the worksheet, quitting Excel and starting it up
again, Excel seems to return to the default state of allowing people to
select both Unlocked and Locked Cells. As such, it seems to ignore the
Worksheet Protection I set earlier.

Am I missing a (logical) step here? Or alternatively, if this is an
'undocumented feature' of Excel, is it possible to add some VBA code that
simply takes away the possibility to select Locked Cells when the sheet is
loaded?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet protection yemi Excel Discussion (Misc queries) 3 May 20th 05 10:12 PM
Worksheet tab protection Xlim Excel Discussion (Misc queries) 2 January 16th 05 01:34 PM
Worksheet tab protection Xieng Lim Excel Discussion (Misc queries) 0 January 16th 05 04:03 AM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM
Seeking help for total worksheet protection Joseph Geretz Excel Discussion (Misc queries) 10 December 31st 04 06:48 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"