PDA

View Full Version : Shared Workbook?!! PLEASE HELP



SDave
01-07-2010, 07:12 AM
Afternoon all,

I've just finished creating an Excel model which works fine as it is, however when I try and share the file I receive the following error message:

Runtime Error 1004
Method 'Unprotect of object'_Workbook' failed

Is there anything that I can do to get around the problem?

The whole point of sharing the file was to enable multiple users to enter data into their specified worksheets?!

I have attached a copy of my file FYI.

The usernames and passwords to unlock or should I say release each sheet can be found behind the Outlook Progress Bar jpg. on the front sheet.

Any help would be much appreciated. I'm beginning to tear my hair out!!!

Thanks.

Bob Phillips
01-07-2010, 07:43 AM
Unprotect does not work with shared workbooks.

Shared workbooks are evil, see 'Features that are unavailable in shared workbooks ' in help.