Protecting worksheets with Macros in Shared Workbooks

  • Thread starter Thread starter Dancing Fish
  • Start date Start date
D

Dancing Fish

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.
 
See one reply at one of your other posts.


Dancing said:
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.
Click to expand...
 
Back
Top