Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wrote a conversion program for Excel workbooks created by my company's
application. The main object of this conversion is to remove a no longer necessary macro from the workbook. This is done by removing the entire code module, so people no longer are asked whether they want to allow macros. The 'Are you sure' message is being suppressed with DisplayAlerts = False, which works for almost all of my customers. However, one customer, who thanks to Murphy has 2500 files to convert, is continuously asked if he is sure he wants to remove the macro. My question: Is there a setting in Excel that prevents the working of the DisplayAlerts statement or is there something else that can have this effect? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel | |||
Tough One: displayalerts = false while OUTSIDE VBA | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming |