Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My Shared workbook is driving me crazy!!!
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 |
#2
|
|||
|
|||
Search Excel's help for: "Features that are unavailable in shared workbooks".
You'll find that worksheet protection can't be changed. I think you'll have to either compromise (take off protection or take off sharing--or change your philosphy). Paul. wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headers on a Shared Workbook | Excel Discussion (Misc queries) | |||
How to keep users from entering a password on a shared workbook? | Excel Discussion (Misc queries) | |||
Shared workbook - one at a time? | Excel Discussion (Misc queries) | |||
Shared workbook protection | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |