Unprotecting Worksheets in Shared Workbooks with Macros

  • 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 i
something to do with the fact it is a shared workbook. Basically, i ge
a message saying "unprotect method of worksheet class failed".

What are the particulars of this and is there a way round it?

Please help.

DF
 
Look at excel's help for: Features that are unavailable in shared workbooks

You'll see this (taken from xl2002):

Protect or unprotect Existing protection remains in effect.
worksheets or the workbook


There's lots of things that are unavailable in shared workbooks.

My workaround is to not change protection or not use shared workbooks.

(Not very helpful, huh?)
 
Back
Top