| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you create a macro on a protected sheet?
I have a shared worksheet that I have password protected so no one can change
formulas in the cells. I would like to set up macros to provide me with a certain view for printing and research. Everytime I set up the macro and protect the sheet it says that I can not use the macro. Is there anyway around this or will I have to unprotect the sheet everytime I want to use the macro? Any ideas or suggestions would be greatly appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Macro that password protects a sheet | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
