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