Hi,
Was wondering how to perform macro actions in the background, without the user seeing what happens on the screen, I know it can be done, just can't remember how!
Thanks
C19
Printable View
Hi,
Was wondering how to perform macro actions in the background, without the user seeing what happens on the screen, I know it can be done, just can't remember how!
Thanks
C19
Apologies,
Already solved my own questions
Code:Application.ScreenUpdating = False
'code here
Application.ScreenUpdating = True
Also : Application.DisplayAlerts = false 'hides pop up questions/confirmations
Hi,
I know this is off the topic of the post but do you know how to open an access database from excel as if i explored to it and opened it?
Thanks
C19
Why do you need to open the database? Is your real intent to get data from the db?
No, I have a form that updates a database with excel data, but once the database is updated, i would like a message box to popup asking if the user would like to open the database.