Is there a way to make the text blink on and off using Excel V
 

Help! When I use this macro it stops working if I protect the worksheet. This
message comes up: "Unable to set the color index property of the font class."
Is there a way around this?
--
News Gal


"Gary''s Student" wrote:

http://www.cpearson.com/excel/BlinkingText.aspx
--
Gary''s Student - gsnu200745


"Glenn" wrote:

I'd like to highlight various anomalies in text field content, by making the
text in them blink (disappear/reappear programatically).

Can it be done?

Is there a way to make the text blink on and off using Excel V
 

You need to unprotect the sheet or protect it with the UserInterfaceOnly
setting as True:


Worksheets("Sheet1").Protect Password:="MyPassword", UserInterfaceOnly:=True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Newsgal" wrote in message
...
Help! When I use this macro it stops working if I protect the worksheet.
This
message comes up: "Unable to set the color index property of the font
class."
Is there a way around this?
--
News Gal


"Gary''s Student" wrote:

http://www.cpearson.com/excel/BlinkingText.aspx
--
Gary''s Student - gsnu200745


"Glenn" wrote:

I'd like to highlight various anomalies in text field content, by
making the
text in them blink (disappear/reappear programatically).

Can it be done?