Hello! 
I understand it is not possible to protect/unprotect a workbook while it is shared.
Yet, I realy need that feature on a VBA code I'm writing.
I have a shared workbook that I want to protect of spontaneous editing, it means it can be manipulated by only using a toolbar I added.
I replaced the protection feature with Sheet_change event that prevents the user from editing the worksheet but there are other options I want to disable, like rename a worksheet or add/delete a worksheet and I can't use protect workbook because the macros should use any available feature of the excel.
If U have an idea for turning on/off the protection while the workbook is shared or how to execute the options I mentiond without it let me know.
Have a nice day!
Noam
I understand it is not possible to protect/unprotect a workbook while it is shared.
Yet, I realy need that feature on a VBA code I'm writing.
I have a shared workbook that I want to protect of spontaneous editing, it means it can be manipulated by only using a toolbar I added.
I replaced the protection feature with Sheet_change event that prevents the user from editing the worksheet but there are other options I want to disable, like rename a worksheet or add/delete a worksheet and I can't use protect workbook because the macros should use any available feature of the excel.
If U have an idea for turning on/off the protection while the workbook is shared or how to execute the options I mentiond without it let me know.
Have a nice day!
Noam
