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
|