Ms access application screenupdating
Thanks, taduh Alainbryden, I used your second alternative because I'm calling the Print PDF subroutine to print a variety of different reports on different worksheets. Unfortunately, I got the following error: "Application-defined or object-defined error" Any suggestions?
taduh I've decided to live with the flashing - there's no real way to stop it and it allows the user to see what's going on - Zorvek - 50 points for your time and effort - I appreciate it.
Those are things that excel records in macros, but that can always be circumvented.
You can use the Worksheet Function property in Excel VBA to access Excel functions. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA calculates the average of the values in cell A1 and cell A2 and places the result into cell A3. You can manually recalculate the workbook by pressing F9. In most situations, you will set calculation to automatic again at the end of your code.
To insert the formula itself into cell A3, use the following code line: Sometimes you may find it useful to disable screen updating (to avoid flickering) while executing code. You can instruct Excel VBA not to display alerts while executing code. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA closes your Excel file and asks you to save the changes you made. To instruct Excel VBA not to display this alert while executing code, update the code as follows. As a result, Excel recalculates the workbook automatically each time a value affecting a formula changes.
I use application.statusbar to keep the users apprised of what is happening.
I have tried using application.screenupdating = false both before I branch to a report subroutine and also within the report subroutine in an attempt to keep it from shifting the focus to the report page, but it is not working.