loading gif

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Thanks Andrew, I had a look the link that you gave here. It will show the gif every time when I click back to this sheet, but what if the macro code has finished excecuting, will this gif disappear automatically?


Thanks
Frank
 
Upvote 0
You don't have to use the Worksheet_Activate event procedure that was just an example. Activate the sheet at the beginning of your code and show the gif. Hide the sheet at the end of your code.
 
Upvote 0
I am sorry, i am so new to this, maybe can you make a simple excel file as example?

Thanks
Frank
 
Upvote 0
I understand now, you mean to make an extra sheet to put the gif in, and at the end of the macro to hide this sheet.
It sounds nice.
I will have a try.

Thanks
Frank
 
Upvote 0
and is there parameter to change the background color of the webpage instead of standard white? or to remove the Arrows of the webpage in the right side?

Thanks a lot.
 
Upvote 0
frankrss said:
and is there parameter to change the background color of the webpage instead of standard white? or to remove the Arrows of the webpage in the right side?

Thanks a lot.
Click to expand...

You can remove the ScrollBar like this:

HTML: 
WebBrowser1.Navigate "about:<html><body scroll='no'><img src='http://www.plenck.de/loading.gif'></img></body></html>"
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Simulating a button being pressed to download a PDF file.
Replies
0
Views
99
ScooterNorm
S
Jimmypop
  • Question
Resize Image inside a Image Control on userform
Replies
8
Views
2K
BurqanKpln
B
M
  • Question
textBox AfterUpdate firing unexpectedly
Replies
3
Views
126
RoryA
RoryA
I
  • Question
Construction Budget distribution using GAMMADIST Function
Replies
3
Views
156
ibrahimdaas
I
S
  • Question
Web Query doesn't load for the website
Replies
1
Views
129
John_w
J

Forum statistics

Threads
1,214,521
Messages
6,120,018
Members
448,937
Latest member
BeerMan23

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top