View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default want to share workbook but limit the sheets each user sees

So, what exactly are you asking for?

Pete

On Nov 4, 11: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.