G
Guest
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.
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.