G
Guest
Hi everyone,
I am experiencing a problem with a shared workbook with a protected sheet
that is driving me crazy.
I have a document with a protected sheet and a Macro that sorts this
protected list >when I protect the sheet I allow SORTING and AUTOFILTER.
Once the sheet is protected I go to the VBE and set the protection for
userinterface only in the private workbook module linked to the open
workbook_event:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub Workbook_Open()
Sheets("Critical Path").Protect Password:="",UserInterfaceOnly:=True
End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Then I close the workbook and reopen it to enable "UserInterfaceOnly"
Then I share the workbook and run My Macro which sorts the protected sheet
with no problems
Then I save and close the workbook
Then when I reopen it and cannot run the Macro anymore. Actually the problem
comes from the Above code bcse just after opening the workbook I receive an
error message saying:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Run-time Error 1004':
Application-defined or object-defined error
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Does somebody knows how to solve the problem ?
Woul really much appreciate any help on this
Regards,
Paul
I am experiencing a problem with a shared workbook with a protected sheet
that is driving me crazy.
I have a document with a protected sheet and a Macro that sorts this
protected list >when I protect the sheet I allow SORTING and AUTOFILTER.
Once the sheet is protected I go to the VBE and set the protection for
userinterface only in the private workbook module linked to the open
workbook_event:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private Sub Workbook_Open()
Sheets("Critical Path").Protect Password:="",UserInterfaceOnly:=True
End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Then I close the workbook and reopen it to enable "UserInterfaceOnly"
Then I share the workbook and run My Macro which sorts the protected sheet
with no problems
Then I save and close the workbook
Then when I reopen it and cannot run the Macro anymore. Actually the problem
comes from the Above code bcse just after opening the workbook I receive an
error message saying:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Run-time Error 1004':
Application-defined or object-defined error
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Does somebody knows how to solve the problem ?
Woul really much appreciate any help on this
Regards,
Paul