View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
susie susie is offline
external usenet poster
 
Posts: 10
Default overwrite Excel SaveAs function from File menu

When user click on SaveAs from File menu in excel, I would
like to send a message to the user that they are not
allowed to rename the file with a new file name to
U:\company and Save button will be disabled right away.
However the message should not popup if the user save the
file to any foler other than U:\company

Any idea on how to accomplish this?
Thank you.
Susie