How can I make an object from the drawing toolbox bar to blink/flash?

Use an ontime macro to change the color every second or half second.

See Chip Pearson's site for blinking text code.

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

Adapt that code to your drawing object.


Gord Dibben MS Excel MVP



On Sat, 19 Sep 2009 18:58:01 -0700, Alberto Ast
wrote:

How can I make an object from the drawing toolbox bar to blink/flash?

Are you familiar with this code? it works but it is making conflict with
anotehr code I already have on This Worksheet View code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not blnClose
End Sub

Do you know how can I fix this conflict... Chip P routine has on same view
code as follows

Private Sub Workbook_Open()
StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlink
End Sub

which cause conflict.



"Gord Dibben" wrote:

Use an ontime macro to change the color every second or half second.

See Chip Pearson's site for blinking text code.

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

Adapt that code to your drawing object.


Gord Dibben MS Excel MVP



On Sat, 19 Sep 2009 18:58:01 -0700, Alberto Ast
wrote:

How can I make an object from the drawing toolbox bar to blink/flash?

Hi Alberto

Try the below...

Private Sub Workbook_Open()
StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not blnClose
If Cancel = False then StopBlink
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

Are you familiar with this code? it works but it is making conflict with
anotehr code I already have on This Worksheet View code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not blnClose
End Sub

Do you know how can I fix this conflict... Chip P routine has on same view
code as follows

Private Sub Workbook_Open()
StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlink
End Sub

which cause conflict.



"Gord Dibben" wrote:

Use an ontime macro to change the color every second or half second.

See Chip Pearson's site for blinking text code.

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

Adapt that code to your drawing object.


Gord Dibben MS Excel MVP



On Sat, 19 Sep 2009 18:58:01 -0700, Alberto Ast
wrote:

How can I make an object from the drawing toolbox bar to blink/flash?

Thanks... I think I am complicating my file too much for now... I will leave
it without the blink... I rather validate the closing.... I might try
later... your subtutine did not work for me now... I will prepare it later to
put it on the web to see if you can help me further.

Thanks

"Jacob Skaria" wrote:

Hi Alberto

Try the below...

Private Sub Workbook_Open()
StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not blnClose
If Cancel = False then StopBlink
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

Are you familiar with this code? it works but it is making conflict with
anotehr code I already have on This Worksheet View code

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = Not blnClose
End Sub

Do you know how can I fix this conflict... Chip P routine has on same view
code as follows

Private Sub Workbook_Open()
StartBlink
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopBlink
End Sub

which cause conflict.



"Gord Dibben" wrote:

Use an ontime macro to change the color every second or half second.

See Chip Pearson's site for blinking text code.

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

Adapt that code to your drawing object.


Gord Dibben MS Excel MVP



On Sat, 19 Sep 2009 18:58:01 -0700, Alberto Ast
wrote:

How can I make an object from the drawing toolbox bar to blink/flash?