Can I disable SAVE

  • Thread starter Thread starter Sparky
  • Start date Start date
S

Sparky

I would like to disable the save button on one of my books. I want users to
be able to enter information and run 'what-if's' but not be able to save it
to the original file. Leaving SAVE AS would be nice, but not necessary. Is
there an EASY way to do this (I don't really understand VB).

Thanks in advance.
 
It's complicated, even if you DO understand VB, as there are so many ways to save a workbook:
from the file menu, with CTRL+S, I think with one of the function keys, etc. All of those must
be disabled.

If you are on a network, what about putting the file in a directory to which the users don't
have write permission?
 
There a few ways to do this. The best way to work out what you need is
to look at the "read-only file access" help topic.
 
There are various things you can do.

You can set it up as read only - It comes up with a
message box, asking whether they want read only (however
it still allows read/write access if they click on NO)

You can add a password to the file if someone wants to
modify it.(this can be a problem if you forget the
password)

Both of the above can be done by opening your file, click
on file - save as -(under save as is an options button) if
you click on this it allows the above options to be
selected - then just click on OK.

Hope this helps,
Nav
 
Thanks - you've all given me a few ideas.


Nav said:
There are various things you can do.

You can set it up as read only - It comes up with a
message box, asking whether they want read only (however
it still allows read/write access if they click on NO)

You can add a password to the file if someone wants to
modify it.(this can be a problem if you forget the
password)

Both of the above can be done by opening your file, click
on file - save as -(under save as is an options button) if
you click on this it allows the above options to be
selected - then just click on OK.

Hope this helps,
Nav
Click to expand...
 
Back
Top