Currency
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 |
Currency
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/ |
Currency
Thanks, Its working Perfectly now!! ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com