Can it be done to open a sheet in Excel with macro which stays invisible?
Printable View
Can it be done to open a sheet in Excel with macro which stays invisible?
Hi,
Application.ScreenUpdating = False
Sheets(1).Visible = True
'Do your actions here
Sheets(1).Visible = False
Application.ScreenUpdating = True
This will stop the screen from updating while the sheet is made visible, meaning that it will not be displayed on the screen to a user. Once the work is done the sheet is made invisible again before turning on the ScreenUpdating.
Hope this helps.
Z
You can still read to and write from sheets which are not visible. Try it.
zaza
Can you really? I'm off to try it! Nice!
MZ