Disabling the Macro alert dialog in Excel - Help Needed 
Author Message
 Disabling the Macro alert dialog in Excel - Help Needed

Hello,

Does anyone out there know of a way to disable the "You are about to run a
macro"
dialog in Excel on the fly ?

We have a VB program which builds an Excel spreadsheet (quite a number of
sheets
actually), and as it is building, on some, it comes up with a dialog which
warns of the
above.

Now, without ticking the checkbox (To allow macros to run), we need to be
able to
continue without intervention.

regards
Mick Burian



Sat, 17 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Disabling the Macro alert dialog in Excel - Help Needed

2. Disabling the Macro alert dialog in Excel - Help Needed

3. need help: Open Excel, run macro, save file, close Excel

4. HELP - Need to Suppress Dialog Boxes w/in Macros

5. help, vb shells excel - need to disable mouse and key input

6. Dialog Disable / Enable Macros

7. URGENT--Need help starting excel macro from access

8. Excel Macros - need help!

9. Excel Macro Help Needed

10. Need help writing an Excel macro

11. Excel Macro help needed

12. Need help converting Excel 4 macros to VB

 

 
Powered by phpBB® Forum Software