Problem with shared network workbook

[Denzil]

Hello everyone

I have a dilema, I have just modified a workbook for multiple network users, from the link below. I have almost come to the finish and testing it on the server, when a problem occured with sharing the file.

Basically ive tested it pre shared, then shared the wookbook and it runs an error, its a run time error 1004, and it sez " method project of object_worksheet failed

Has anyone any ideas as to what the prolem could be please??

Many Thanks Denzil

http://www.excelforum.com/excel-prog...ord-login.html

[dominicb]

Good afternoon Denzil

Difficult to say without seeing your file, but ...

Just had a quick scope of the thread you posted and it seems that you are using Excel's built in protection. If you are attempting to apply and unapply Excel's protection programmatically through a shared workbook, then you'll have to think up an alternative - it's not allowed.

Copy the below and paste it into Excel's help search page :
Features that are unavailable in shared workbooks
for a whole list of features / feeble workarounds that come into play with shared workbooks.

HTH

DominicB

[Denzil]

hello dominic

Thanks for your reply its much appreciated!! Sorry Ive took so long, work has been crazy today

Can you think of any ways around the problem? Im kinda in to deep at the mo!

Many Thanks

Denzil

[dominicb]

Hi Denzil

Can you think of any ways around the problem? Im kinda in to deep at the mo!

No workarounds. Unfortunately it's an Excel thing.
You're either going to have to live without the protection, or the shared functionality of the workbook.

HTH

DominicB

[dominicb]

Hi Denzil

Actually you might be able to leave the protection off and code something into the worksheet change event that looks at the protection property of each cell, and if the cell should be protected, then the user is prevented from changing the contents?

Just a thought.

HTH

DominicB

[Denzil]

Hello Dominic

Is there any chance you could have a look at my workbook please, to see if you can have any joy with it, as I explained before, I kind of fumbled my way to this point, taking bits and bobs from stuff on this site.
Below is the Link to the complete document.

The administrator user name is jamie, and the password is joshua

http://www.humyo.com/6559135-196912777

Many Thanks

Denzil

[dominicb]

Hi Denzil

OK, I've had a look at your file, but it will take me longer to integrate this sort of thing into your file as you know it better than me, so I'll give you the code.

Have a look at the attached file.
I clicked on the top left of the spreadsheet area to highlight all cells and pressed Ctrl + 1, Protection and unlocked them all. I then locked all the cells shaded light blue. You will now find that protection is switched off and you can't change the shaded cells because of the event procedures I have (see the code behind Sheet 1).

For development purposes if you want to edit the shaded cells, go to the VBE (Alt + F11) and press Ctrl + g to open the "immediate window" - this is where commands are entered and executed immediately.
To "unprotect" sheet type
application.enableevents=false <enter>
to "protect" sheet type
application.enableevents=true <enter>.

HTH

DominicB

[Denzil]

Hi Dominic

Thanks for the speedy reply!

That looks good! Ill have a play and let you know how i get on

Many thanks

Denzil