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

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