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......
|