I am using Excel 97.

I have shared a workbook but the unprotecting code which worked fine when it
wasn't shared:

Worksheets("Data").Unprotect Password:="maw3327"

is causing a runtime of 1004, method of unprotecting not available.

To reprotect I am using:

Worksheets("Data").Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True, Password:="maw3327"

I don't know whether this may potentially cause me a probblem because I
can't get that far!

Please can anyone else with a solution.


--
Mark