Forum Discussion
Deleted
May 08, 2019Setting 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...
Wyn Hopkins
May 08, 2019MVP
HI Deleted
That would require some complex VBA programming to set up
It's not possible with standard Excel functionality
Deleted
May 13, 2019- Wyn HopkinsMay 13, 2019MVPI 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.