Thank you,

That seems much too easy :-) But you are correct

"Spiky" wrote:

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.