View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Overriding the menu "Save" option?

If my users click "Save", I need to stop them from actually
saving any changes to my workbook. I want my workbook
to be unchangeable, and if someone clicks "Save", I want
to call a separate subroutine which will write data to a separate
file.

Can anyone provide any help on over-riding the "Save"
option and making my workbook unchangeable??

thank you