Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to protect sheet
Hi,
That's the default for sheet protection so use Sub sonic() 'Your code ActiveSheet.Protect Password:="mypass" End Sub "richzip" wrote: I have macro code set up to copy data from a large worksheet into a template, and then save the template with a new name. I would like to protect the worksheet after copying the data onto it. I want the options "select locked cells" and "select unlocked cells" to be the only ones checked. What macro code can I add to accomplish this? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Sheet Macro | Excel Worksheet Functions | |||
Macro with protect sheet | Excel Discussion (Misc queries) | |||
Protect sheet in macro | Excel Worksheet Functions | |||
Using macro to un/protect sheet | Excel Worksheet Functions | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |