Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
some 'Protection' questions
Hello
I have a workbook nearing completion and I'm now adding (well, attempting) protection. I have some questions: a) Each worksheet has regions of unlocked cells, the others being locked. I can protect each work sheet one-by-one. Is there a way to protect them all at once? (Selecting all tabs leaves ToolsProtectionProtect Sheet ... grayed out.) b) My worksheets contain macros that either hide or show columns using Subs with code fragments like 'Columns(N).Hidden = False'. When a worksheet is protected with the default 'select locked cells' and 'select unlocked cells' checked, I can't run the macros. If I also check the 'format columns' protection option, the macros work properly, but the user can alter column widths (undesirable). Is there an easy solution? c) I have many worksheets with several regions either locked or unlocked. Is there an easy way to show the locked status of each cell without having to check each one individually? d) I think this one is really dumb, but here goes. I took a test excel file and fully protected each sheet and the entire workbook (both structure and windows). As expected, I couldn't really do anything after that, but I could go into explorer and erase the entire file. Is this easily preventable? Much thanks Bri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
protection on excel forms | Excel Worksheet Functions |