Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run macros on protected worksheet
I have a protected worksheet that is located on a shared drive. Everyone
accesses and uses it in a read-only format. I have protected various cells within the worksheet so that everyone can use tab to navigate only to the unprotcted cells that require input data. I created a macros to clear all of these unprotected cells at once so that the spreadsheet can be re-used easily with less error. I do not want to allow anyone to unprotect the worksheet, but they cannot run the macro in a protected status. Please help. Thanks. Excel 2002, Windows XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) | |||
Sort Columns in Protected Worksheet, etc. | Excel Worksheet Functions | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Sorting on a protected worksheet | Excel Discussion (Misc queries) | |||
Insert comment in protected worksheet | Excel Worksheet Functions |