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<

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

Hope it helps,

Cesar Zapata



"agfraser76" wrote in message
...

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

because there are two sheets that I need changing at the same time it
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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/