want to share workbook but limit the sheets each user sees
On Nov 4, 5:48*pm, Mikekne wrote:
I have a budget workbook with different tabs for each department. *These tabs
are also linked into support tabs. *I would like to be able to save a master
workbook for each department but only allow them to see their own department
tab (10 different workbooks, each showing a different tab). *Then use the
merge function to bring all the changes into the master.
If you are going to give them each a separate file, anyway, why is
there an issue? Give them each a file with one worksheet for their
department, and have your master file reference each one.
|