Hi All,
Can you tell me is there any way to share individual sheets in Excel 2013 so that upon sharing they can only see one sheet and not the while workbook?
Hi All,
Can you tell me is there any way to share individual sheets in Excel 2013 so that upon sharing they can only see one sheet and not the while workbook?
Hi
I'm assuming you want to share different sheets with different users. If this is not the case, simply hide all the other sheets then password protect the workbook structure so people can't unhide the worksheets.
Otherwise, the short answer is "Not that I'm aware of."
However, there are ways and means involving macros, hidden sheets and passwords. Some options:
- Have a macro that exports a specific sheet to a separate file then imports again once required updates are done.
- Hide all sheets in the workbook and password protect it. Have a list of usernames in the sheet. A macro reads the user's name, using ENVIRON("Username"), then unhides the appropriate sheet. This is probably open to abuse. Excel passwords are relatively easy to break and there are plenty of macro examples around that can do this.
I hope some of this helps.
Cheers, Rob.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks