startblink

Dear All, I want a particular cell to blink until the value set to today's date. following is the code used. Option Explicit Public RunWhen As Double Sub StartBlink() With Worksheets("Summary") .EnableOutlining = True .Protect Password:="isuzu", _ Contents:=True, UserInterfaceOnly:=True End...

Morning all, I'm not a VBA pro, so you can imagine my delight when I managed to auto start a macro, that made the test in one of my cells "blink". However, the file now opens everytime I close it - because I haven't ended my Application.OnTime and I just can't get my head round it. So, in my...

Hi all, I took this code from another spreadsheet and need it simplified. I was able to get the cell to change color, but not blink. I am wondering if it is because the code refers to indexes. Anyway, my code would be much more simple. Here is the data. 1 is good 5 is bad. So the code would...

Hello, everyone, I have a macro in which if in C2 = 2, the lines of A2: R2 begin to blink. Please ask for help on your part - how to change it to check every cell in the range C2:C and if some C2,3,4,5 ..... and so the end of the same row to blink these lines . Example: If C2=2, blink lines...