VBA to Unprotect/Protect Worksheet - for a shared workbook

[surkdidat]

I am not sure what I need is possible, but worth asking!

I have shared workbook that is also has the sheet protected (no password)

I have an existing macro that to run, needs to unprotect the worksheet, run, then protect again.

When not shared it works fine, but cannot run when shared (due to the unprotect/protect situation)

Any ideas, gratefully received!

 

[dmt32]

Hi,
there are a number of functions that are not available If you have set your workbook to share & changing the workbook / worksheet protection status in vba I think you will find is one of them hence the reason maybe for the error you are getting.

Have a read here:https://social.technet.microsoft.co.../common-issues-of-shared-workbook?forum=excel


for some further guidance.

Dave

 

[surkdidat]

Hi - apologies had a chance to check this until now due to people being in it! If I do not open it as a shared workbook, it works fine. ThenI can share it. If I open it up as a shared book I get an error of "Application - Defined or object defined error." Is there a way on opening it can do the above code, and then automatically share the workbook please? (although I am guessing that this will not help as the workbook will be closed as "Shared"???

Did not read this before previous post.

If you unprotect the sheet and run te macro, do you ave the same error?