View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
No Name
 
Posts: n/a
Default Can you disable "File - Save As"?

I agree with what Dave says in that what you seek is a slippery slope and
can get very complicated quickly, and still end up being defeated.

That being said, you could hardcode the full filename and disable
functionality or do whatever you need to do if the file has been renamed or
moved.


"Alan Smith" wrote in message
...
I have a file that numerous people will be using, and I would like to keep
it
as just one version. Is it possible to allow users to save their updates,
but
not to Save As another name?

I have some macros in the file, and am protecting most of the sheets
through
VBA, if that makes any difference.

Thanks in advance,

Alan