Excel run macro without updating screen
The following list summarizes the various macro security settings.Under all settings, if antivirus software that works with Microsoft Office is installed and the workbook contains macros, the workbook is scanned for known viruses before it is opened.Macros are recorded in the Visual Basic for Applications programming language.
For more information about macro security settings in Microsoft Office documents, see Enable or disable macros in Office files.I can do all of this apart form the last bit where I access the report and write the data onto the reports controls. (just a personal joke there) I have as much knowledge of Access as the huns have of European football after Christmas.In Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook.In Excel 2003, all macros are run without restrictions.
This security level does not protect against malicious programs, does not allow for acceptance of certificates of trust, and is not considered secure in general. I think the syntax was somthing like "windows.pane=off" Thanks in advance.