View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How can I make my data show as flashing in Excel?

As Gord said originally - Don't Bother !!

Did you read the caveat on Chip's site? i.e.:

" ... Blinking text ... may be in violation of Section 508 of the
Rehabilitation Act Of 1973 (since blinking text can cause seizures in
epileptic patients) ... "

Pete

On Mar 4, 2:31*pm, Julia wrote:
This was great - thank you. *My boss loved it. *Now I have another question.

The report I am working on is set up with one Excel document containing
several worksheets each having it's own macro for blinking text; however,
when I try closing the document, it won't close. *I know it has something to
do with the following code provided in the previous message you sent, but
because of my inexperience in this area, I can't figure out how to make it
work for each of the worksheets in the document in order for it to close. *
Any ideas?

Private Sub Workbook_Open()
* * StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
* * StopBlink
End Sub



"Gord Dibben" wrote:
Don't bother.


Everyone will hate you.


But if you insist, see Chip Pearson's site for VBA code.


http://www.cpearson.com/excel/BlinkingText.aspx


Gord Dibben *MS Excel MVP


On Fri, 22 Feb 2008 09:47:02 -0800, Julia
wrote:- Hide quoted text -


- Show quoted text -