Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello everyone...
Just wondering what the line of code would look like that protects a sheet via the press of a (macro) button. For reason undisclosed, I dont want users to go the Tools / Protection routine, but I can only get the macro to work without password protection. Here is what I am using: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True but again this only works without a password. Any ideas? -- Regards... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |