Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Protection
I have a macro to automatically protect my sheets. This macro i designed to only allow the selection of Unlocked Cells. ActiveSheet.Protect "a" ActiveSheet.EnableSelection = xlUnlockedCells It works fine for every sheet I've used it on up until I re-load i after I've saved it. (Namely, the locked cells can't be selected, bu the unlocked ones can.) When I re-open the workbook, the sheet is still protected, but I ca select Locked Cells and Unlocked Cells. (Only the Unlocked ones can b editted, of course.) Does anyone know of a way to fix this? ie. Change my macro so tha this problem does not occur? Thanks, Scot -- Maistry ----------------------------------------------------------------------- Maistrye's Profile: http://www.excelforum.com/member.php...fo&userid=3607 View this thread: http://www.excelforum.com/showthread.php?threadid=56619 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
sheet protection | Excel Discussion (Misc queries) | |||
Protection sheet | Excel Programming | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming |