Currency

  • Thread starter Thread starter agfraser76
  • Start date Start date
A

agfraser76

I have a sheet with a button that when you click on it it selects
range of other cells and changes the currency of the number by goin
through the right click option.

because there are two sheets that I need changing at the same time i
flickers and does not look good.

I was wondring if there is a way of changing the Currency from £ to
on two separate sheets with a macro and not causing flickering
 
that flickering is cause when excel refreshes. To turn off this
"flickering" you need to use screenupdating.

sub mymacro
application.screenupdating = false ' this stop excel from refreshing.
your macro here<
Click to expand...

application.screenupdating = true ' Make sure you enable it.
end sub

Hope it helps,

Cesar Zapata
 
You did not post your code but try
application.screenupdating=false
your code
reset to true
 
Back
Top