Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul.
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Headers on a Shared Workbook jessica Excel Discussion (Misc queries) 1 April 29th 05 09:46 AM
How to keep users from entering a password on a shared workbook? alady31 Excel Discussion (Misc queries) 1 March 24th 05 06:19 PM
Shared workbook - one at a time? andy Excel Discussion (Misc queries) 1 February 8th 05 04:56 PM
Shared workbook protection zeek Excel Discussion (Misc queries) 1 December 13th 04 02:30 PM
Problem with shared workbook (history sheet) ACH Excel Worksheet Functions 2 December 9th 04 09:39 PM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"