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...
Hi
There are techniques using VBA that can make it very difficult for people to access certain sheets but you need some experienced in VBA to get it to work really well.
If you have O365 then something like SharePoint could be an option (not an expert in that area but maybe post on the SharePoint community forum)
There are techniques using VBA that can make it very difficult for people to access certain sheets but you need some experienced in VBA to get it to work really well.
If you have O365 then something like SharePoint could be an option (not an expert in that area but maybe post on the SharePoint community forum)