Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
hmm....all i can think of is recording the whole formatting program an running the macro each time a new work sheet is added. i'm sure there's some vba code that states 'IF new worksheet added, ru macro "xxx"' try using the help assistant i guess... sorry i couldnt help much. f -- FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup acces |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
Hi guys,
I couldn't find the begining of this thread in Google, but have you considered the following solution. It has the advantage of preserving the undo functionality of Excel and the disadvantage of a constantly running code. Regards, KL 1) Create a named formula called TIMER =MOD(SECOND(NOW()),2)=1 2) Select the range you want to blink subject to a condition (or multiple conditions), say range A1:A100 3) Apply the following Conditional Format =TIMER*(A1<0) where (A1<0) is one of the many possible conditions. 4) put the following code into the VBA module of ThisWorkbook: Private Sub Workbook_BeforeClose(Cancel As Boolean) StopBlinking End Sub Private Sub Workbook_Open() StartBlinking End Sub 5) put the following code into a standard module (say Module1): Dim dtNext As Date Sub StartBlinking() dtNext = Now + TimeValue("00:00:01") Application.Calculate Application.OnTime dtNext, "StartBlinking" End Sub Sub StopBlinking() Application.OnTime dtNext, "StartBlinking", schedule:=False End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
kudos KL, but does that mean that my workbook would still restart when i qui it? thanks, f -- FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup acces |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
I'd be surprised if it did :-)
KL "FloggingDolphin" <FloggingDolphin.1s5zqc@ wrote in message ... kudos KL, but does that mean that my workbook would still restart when i quit it? thanks, fd -- FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
hey there, thanks for that advice. Can you just teach me how to name formula called TIMER. Is that a Macro or something? I tried to chec excel help on how to create and name formulae but failed. thanks f -- FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup acces |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blinking Cell (Worksheet restarts)
Hi FloggingDolphin,
This is [almost] exactly the same as a named range. Essentially when you create a named range you create a named formula as you enter something like =A1 which is a formula refering to a range. So the step-by-step is: 1) on the spreadsheet window go to menu InsertNameDefine 2) enter "Timer" (w/o quatation marks) into the 'Names in workbook' box 3) enter =MOD(SECOND(NOW()),2)=1 into the 'Refers to:' box 4) press Add, OK Voila! Regards, KL Regards, Kl "FloggingDolphin" <FloggingDolphin.1sdtcm@ wrote in message ... hey there, thanks for that advice. Can you just teach me how to name a formula called TIMER. Is that a Macro or something? I tried to check excel help on how to create and name formulae but failed. thanks fd -- FloggingDolphinPosted from http://www.pcreview.co.uk/ newsgroup access |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blinking Cell (Worksheet restarts) | Excel Programming | |||
Blinking Cell (Worksheet restarts) | Excel Programming | |||
Blinking Cell (Worksheet restarts) | Excel Programming | |||
Blinking Cell (Worksheet restarts) | Excel Programming | |||
Blinking Cell (Worksheet restarts) | Excel Programming |