Vintage79
Board Regular
- Joined
- May 29, 2007
- Messages
- 185
- Office Version
- 2019
- Platform
- Windows
Hello all,
I would like to display a 'please wait' image while my code is working. So, Sheet1 is for the user to press a button and activate the code. On the hidden Sheet2 I have an image that I have named as 'Image01'.
I'm thinking that I could use something like this:
When button is pressed to run code:
Call Image01 from Sheet2 and display it on Sheet1
Application.ScreenUpdating = False
Code then runs here
Application.ScreenUpdating = True
Hide Image01
Is this possible? Thanks for any advice!
I would like to display a 'please wait' image while my code is working. So, Sheet1 is for the user to press a button and activate the code. On the hidden Sheet2 I have an image that I have named as 'Image01'.
I'm thinking that I could use something like this:
When button is pressed to run code:
Call Image01 from Sheet2 and display it on Sheet1
Application.ScreenUpdating = False
Code then runs here
Application.ScreenUpdating = True
Hide Image01
Is this possible? Thanks for any advice!