| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro and Protected Sheet Problem
Just turn protection off temporarily for the sheet:
Sub YourMacro() Worksheets("SheetName").Unprotect ' macro code here Worksheets("SheetName").Protect End Sub -- - K Dales "Daniel R. Young" wrote: I have macros that hide rows and I want to protect my sheet so individuals will not be able to change any of the information. When the sheet is protected the macro will not work. It goes to a debuger. Is there a way to run my macros even though the sheet is protected? Thank you, Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro & Protected sheet | Excel Discussion (Misc queries) | |||
| Combobox problem in protected sheet | Excel Discussion (Misc queries) | |||
| Problem doing Query to Access with Excel sheet protected | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
| Solver via VBA on protected sheet problem | Excel Programming | |||
![K Dales[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
