Is there a way to animate cell(s) boards in Excel?

U

UABCSA

Is there a way to animate cell(s) boards in Excel? I think I saw a
spreadsheet in a meeting (overhead projector on a laptop) that had an
animated border in an area of cells of intrest. Please note that this was
NOT a copy, cut, etc command or operation. It was a stand alone feature that
was there when the file opened. Is this possible. Could it be possible that
this was another spreadsheet program?
 
D

Dave Peterson

There's nothing built into excel that does this kind of thing.

I guess you could write a macro that adds a border to the current selection and
then toggles it on/off every few moments.
 
P

Piranha

UABCSA said:
Is there a way to animate cell(s) boards in Excel? I think I saw a
spreadsheet in a meeting (overhead projector on a laptop) that had an
animated border in an area of cells of intrest. Please note that thi
was
NOT a copy, cut, etc command or operation. It was a stand alon
feature that
was there when the file opened. Is this possible. Could it b
possible that
this was another spreadsheet program?
Click to expand...
Hi,
This code will Flash the text from one color to another continousley.
Its set for Red and White now. You can convert it to borders or an
colors you want.
-----
Select your cells, go to format/style put in the name - Flash - se
your
formating and click ok. then run your macro from a standard Module.
-----
Dim NextTime As Date

Sub Flash()
Application.ScreenUpdating = False
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Flash").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
Application.ScreenUpdating = True
End Sub

Sub StopIt()
Application.ScreenUpdating = False
Application.OnTime NextTime, "Flash", schedule:=False
ActiveWorkbook.Styles("Flash").Font.ColorIndex = xlAutomatic
Application.ScreenUpdating = True
End Sub
 
Top