Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run Macro functionality for a protected worksheet
i wanna what to know :-
run macro functionality for a protected worksheet |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run Macro functionality for a protected worksheet
You need to include in your macro an unprotect statement, then reprotect
after the code is complete, replace the sheet name as required...... sub Test() Sheets(1).Unprotect 'your code here! Sheets(1).Protect DrawingObjects:=True, Contents:=True, Scenarios:=True end sub if you need to use a password then change it to......... Sheets(1).Unprotect Password:="MyPassword" Sheets(1).Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="MyPassword" -- Cheers Nigel "aflriwanna" wrote in message ... i wanna what to know :- run macro functionality for a protected worksheet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run Macro functionality for a protected worksheet
You can allow VBA code access to a protected sheet by including the following
parameter in the .Protect statement: userinterfaceonly:=True This does not persist after the workbook is closed, so needs to be initiated each time it's opened. Regards, GS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do not allow Copy/Paste Functionality in a Protected Sheet | Excel Worksheet Functions | |||
Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
Tab key functionality in a protected worksheet | Excel Programming | |||
Enable 'BOLD' functionality in protected Excel spreadsheet | Excel Discussion (Misc queries) | |||
How can I run a macro in a protected worksheet? | Excel Worksheet Functions |