Blinking Text
 

I have read about the new article "Blinking Text" in cpearson website
(http://www.cpearson.com/excel/BlinkingText). I have tried but cannot
run satisfactory. When I open the workbook, it cannot run automatically
unless I run the macro. In addition, how can I modify it so that I can
run it as a function or by pressing a button when selecting any cell ?
Hope someone can give me a hand.

KK

Blinking Text
 

If you change the name of the StartBlink macro to Auto_Open, it
will run when you open the file. I'm not sure what your second
question means.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"KK" wrote in message
oups.com...
I have read about the new article "Blinking Text" in cpearson
website
(http://www.cpearson.com/excel/BlinkingText). I have tried but
cannot
run satisfactory. When I open the workbook, it cannot run
automatically
unless I run the macro. In addition, how can I modify it so
that I can
run it as a function or by pressing a button when selecting any
cell ?
Hope someone can give me a hand.

KK

Blinking Text
 

Thanks, Pearson. I mean how can I change any cell contents to Blinking
Text such as using the Format Painter button. Your example just define
only 1 cell A! in the macro. Can I change to any cell I select will be
changed to Blinking Text.

KK