View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian C[_3_] Brian C[_3_] is offline
external usenet poster
 
Posts: 1
Default Prevent Save in Excel 2000

Hi,

I'm trying to create a worksheet in Excel 2000 to post on an intranet site,
but I don't want users to be able to save copies to their local drives
because we will update reference data periodically.

I tried an auto run macro to disable the menu bar, but I also need it to run
automatically when the worksheet is closed to restore the users defaults (I
don't want any permanent changes to their Excel).

I also tried creating a web site, but I lost too much of the functionality
of the worksheet, so this won't work.

I'd appreciate any help.

Thanks,

Brian