Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection settings not holding
I have a worksheet that I only want a few cells to be edited so I went in and unlocked a few cells then protected the worksheet. On my machine it works great, but when I e-mailed it to a friend he tried it and the whole worksheet is non-selectable. The problem that when I go to protect the worksheet, I'm given the option of picking and choosing what I want to protect and I checked the the "select unlocked cells" box then saved the file. When the other guy opens it back up, the protection settings change to how he has it set up on his machine and the "select unlocked cells" is not checked, therefore he cannot type in the cells like I want. Does this sound right that the protection settings are computer dependent instead of worksheet dependent, and is there an easy way to make my settings hold? Thanks for the help. -- the_real_ptb ------------------------------------------------------------------------ the_real_ptb's Profile: http://www.excelforum.com/member.php...o&userid=37545 View this thread: http://www.excelforum.com/showthread...hreadid=572296 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection settings not holding
I think I have it figured out. Looks like I had an autorun on open macro that was changing the settings. Please disregard. -- the_real_ptb ------------------------------------------------------------------------ the_real_ptb's Profile: http://www.excelforum.com/member.php...o&userid=37545 View this thread: http://www.excelforum.com/showthread...hreadid=572296 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when save as CSV with VBA password protection on | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
2003 Shared Worksheet Protection Settings Failing For My 2000 User | Excel Worksheet Functions | |||
Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel |