View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TroyH TroyH is offline
external usenet poster
 
Posts: 9
Default Sharing Workbook Nighmare

I am creating a workbook that will reside on a network drive. There will be approx. 15 different users accessing this workbook. Here is my delima

The workbook does this
Users will be creating multiple pages which will be copied and deleted from shared workbook when they close
Users will have the ability to add certain data to only 1 sheet of the shared workbook

I have a few users who are very paranoid and want the abilty to save the workbook locally in case of a power outtage, etc

How do I stick with a single shared notebook but allow users the option of saving locally and keeping the data on the one single sheet active

Thanks.