| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make a word flash or blink in excel | Excel Discussion (Misc queries) | |||
| can u make a text in a cell to blink , or change it's color? | Excel Worksheet Functions | |||
| Can you make a number in an excel cell blink? | Excel Worksheet Functions | |||
| In excel, can you make a cell blink? | Excel Discussion (Misc queries) | |||
| How to Make the text blink in Excel? | Excel Worksheet Functions | |||
Linear Mode
