Forum Discussion
Setting permissions to different users to access different spreadsheets within the same workbook
Hi all, I am trying to set permissions to different users to access different spreadsheets within the same Excel workbook. For example, user A will be able to access 'Overall' and 'A' spreadsheet...
I just googled and found this article
http://www.vbaexpress.com/forum/showthread.php?40194-Un-protect-sheet-for-specific-user
I'd only advise doing this if you have good VBA experience, and if the data isn't too sensitive. Excel sheet protection is not particularly strong.
http://www.vbaexpress.com/forum/showthread.php?40194-Un-protect-sheet-for-specific-user
I'd only advise doing this if you have good VBA experience, and if the data isn't too sensitive. Excel sheet protection is not particularly strong.