Shared and Protected Workbook

[ewan1979]

Hi,

I am runinng the code below on a protected worksheet and it runs fine. However when I also add the shared workbook feature there is an error in the code. The system is going to be used by multiple users so it needs to be shared and protected. I have tried using Worksheets("Master").UnprotectSharing to work round this but it doesn't seem to work. Could anyone offer some advice?

Please Login or Register  to view this content.

[ewan1979]

Any ideas folks?

[royUK]

Shared workbooks are not a good idea. You won't be able to have nultiple users entering data with the form. If this is your goal you need MS Access.

I've tidied the code anyway

Please Login or Register  to view this content.