View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Disable Quick Save & Save As

Not sure what you're trying to achieve here but if it's to prevent
unauthorised copying of the file, whilst it will work it's not at all
secure. All the user has to do is what Mike H suggested, ie open the file
with macros disabled, then they can save as they please.
You can prevent uninformed casual users from doing this, but even with those
you need to be far more devious. No matter how devious you are you cannot
prevent anyone with relatively little knowledge and the will to do so from
circumventing your efforts, Excel security is not its strong point.
Regards,
Alan.
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Application.DisplayAlerts = False

'code to run here

Application.DisplayAlerts = True


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 14:35:02 -0700, L Weber

wrote:

Mike,
That was it... Thanks a bunch... Now next question How do I stop
the "XXX.XLS is read only to save a copy.........." It does not allow me
to
do this but I would like to get rid of the pesky dialougue box. Thanks a
bunch for your help......