Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting worksheets with Macros in Shared Workbooks
Hi All,
I have a spreadsheet which has many worksheets and macros. In general, the spreadsheet is protected. However, in the spreadsheet there are macros that unprotect worksheets, do tasks then reprotect. I want to make it a shared workbook. However, there seems to be a problem with the protection which is something to do with the fact it is a shared workbook. Basically, i get a message saying "unprotect method of worksheet class failed". I am using the standard method: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True What are the particulars of this and is there a way round it? Please help. DF. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting worksheets with Macros in Shared Workbooks
See one reply at one of your other posts.
Dancing Fish wrote: Hi All, I have a spreadsheet which has many worksheets and macros. In general, the spreadsheet is protected. However, in the spreadsheet there are macros that unprotect worksheets, do tasks then reprotect. I want to make it a shared workbook. However, there seems to be a problem with the protection which is something to do with the fact it is a shared workbook. Basically, i get a message saying "unprotect method of worksheet class failed". I am using the standard method: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True What are the particulars of this and is there a way round it? Please help. DF. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in shared workbooks | Excel Discussion (Misc queries) | |||
Shared Workbooks-shared headers and footers | New Users to Excel | |||
Protecting a shared worksheet | Excel Worksheet Functions | |||
protecting shared workbook | Excel Discussion (Misc queries) | |||
Macros with shared workbooks | Excel Programming |