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.

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