Hi,
I have a question and after searching high and low I cannot find the answer.
I have recently completed a project based around spreadsheet in Excel to restrict the changes made by users based on the password they enter. This is to allow different groups of users to access the spreadsheet in different ways, as per their role in updating various sections.
In order to do this I have used the "Protect Sheet" option along with some VBA to highlight the various areas to lock & unlock for each set of users. Each password triggers a different VBA routine to change the settings of the relevent cells for that user to update.
This works fine when used exclusively & I was hoping to be able to share the workbook but some key protection macros don't work as expected shared mode. I get an error whenever the VBA code attempts to "Protect" and "Unprotect" the various Worksheets.
So I was wondering if it is at all possible to set a workbook up in such a way that it can never be shared by a user?
Or is it possible there is a way to "Protect" or "Unprotect" spreadsheets when they are in shared mode?
Bit of a long shot I know but any help would be greatly appreciated
I have a question and after searching high and low I cannot find the answer.
I have recently completed a project based around spreadsheet in Excel to restrict the changes made by users based on the password they enter. This is to allow different groups of users to access the spreadsheet in different ways, as per their role in updating various sections.
In order to do this I have used the "Protect Sheet" option along with some VBA to highlight the various areas to lock & unlock for each set of users. Each password triggers a different VBA routine to change the settings of the relevent cells for that user to update.
This works fine when used exclusively & I was hoping to be able to share the workbook but some key protection macros don't work as expected shared mode. I get an error whenever the VBA code attempts to "Protect" and "Unprotect" the various Worksheets.
So I was wondering if it is at all possible to set a workbook up in such a way that it can never be shared by a user?
Or is it possible there is a way to "Protect" or "Unprotect" spreadsheets when they are in shared mode?
Bit of a long shot I know but any help would be greatly appreciated
