VB Syntax for Bypassing Dialog Boxes and Formatting Cells
Posted by Mark Israel on June 27, 2001 6:15 AM
I'm woring on an aout_open macro to import data from Access and create a report in Excel 97. I am almost done, but have three items I'd like to add to the code:
(1) Bypass or select the "Enable Macros" when opening the file. I do not want to permantently turn off macro virus protection.
(2) Once the data is imported, I need to delete the raw data from other workbooks. I want to bypass or select the "Delete Sheet" message.
(3) There is a column that has either red, yellow, or green as the text. I would like macro to search for cells with red and format them with red and so on for yellow and green.
Any assistance would be greatly appreciated.