MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VERY quick question


Posted by M Walker on August 23, 2001 8:33 AM

Hi,

When openning a workbook that contains a macro you get the general "warning". If i include this code ...

Application.Displayalerts=False

In the "ThisWorkbook" will this disable the prompt?

If not how can i?

Cheers,
Matt


Posted by GREGC on August 23, 2001 8:42 AM

That won't disable the message, but it will disable all the warnings in Excel. If you delete something it wont ask you if you want to delete or save. With that line you need to set it back to true before the macro ends.

Posted by neo on August 23, 2001 9:33 AM

you can do that by...

the only way to disable the macros warning is to go into Tools -> Security -> Macros and set it to 'low security'. mind you this only works for the machine you set this on. on a network, it only works for the profile this was set under...

neo