Want to disable save when macros are disabled

[delfiled]

Am using an Excel workbook with macros which is located in a networked
folder. If the user disables macros, then when he terminates the
workbook he is automatically prompted to save the workbook to his local
computer. Is there some way to defeat this behavior so the
workbook is closed silently without the save prompt?

 

[Zack Barresse]

Hi,

Not with Macros disabled, no.

You could use code to control what the user(s) see if they disable macros
though. Here is an example:

http://www.danielklann.com/excel/force_macros_to_be_enabled.htm

HTH

 

[delfiled]

....You could use code to control what the user(s) see if they disable
macros though. Here is an example: ...

Thanks for your reply. My concern is I don't want users trying to save
the workbook back into the source network folder. I trap the saves
when macros are enabled to redirect them to a suitable local location
and I've got the network folder protected so no damage is done, but it
makes for a confusing situation when the user tries to kill the
workbook and he can get put into a save dialog that doesn't (and don't
want it to) work.

 

[Alan]

You can make the workbook useless if macros aren't enabled as Zack
describes, but I don't think you can prevent a user saving it to any folder
they chose if macro's aren't enabled. You can save the original as Read Only
to protect it, but that wont prevent a copy being saved in the same folder,
Regards,
Alan.

 

[Zack Barresse]

The best tool is a well-educated end-user. I'm sure this probably isn't
what you wanted to hear, but most hinges on them. Educate them and you
shouldn't have any problems.

You could also, as a small alternative, check the workbook path on startup -
this of course requires VBA. So either way, you're better off educating
your user(s).