Vba protection in shared workbook

[Melmillw82]

Please help! I have a workbook that has 30 tabs all are the same. I have added a button to protect each sheet and another to unprotect. This is so that when the sheet is full it is locked off so nobody can change the info. My problem is when I share it! I cannot use the buttons. Is there another way I can lock the sheet off as and when I need to while it is shared without having to keep unshareing running vba then sharing again.
Thanks in advance ?

 

[dmt32]

Hi,
Shared workbooks can be an issue & generally, they do not always perform in a way users hope. I personally would avoid them & probably you will find many here feel the same.

Here is one site that gives further reading on the subject:https://social.technet.microsoft.co.../common-issues-of-shared-workbook?forum=excel


I don’t have a specific answer but maybe another here can guide you with your current issue.


As an alternative thought, if your users have access to your workbook across a corporate network, you could consider providing them with a template copy of their part of the workbook that can read read /write its data to & from your master (database) workbook.

This approach would negate the security issue about locking off data you no longer want users to modify although I will hasten to add, Excel security is very weak.

Hope Helpful

Dave