View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikekne Mikekne is offline
external usenet poster
 
Posts: 3
Default want to share workbook but limit the sheets each user sees

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.