Friday, April 01, 2016

How to Create Flashing Cells in M$ Excel

And have them flash when you open your workbook :

start with excel.tips :

http://excel.tips.net/T002134_Flashing_Cells.html (resource)

had to figure out how to do new cell style




turn on the Developer tab

Click on the Macros button. In the Macro dialog that pops up, one of those you already
have will be selected. No problem, in the Macro name : field, start typing : StartFlash

Now, all all buttons that were available get greyed out and the "Create" button becomes
available. Click it and you go to VBA editing - now, paste Allen's code and ensure you
change "Flashing" that he has in 2 places to whatever you called your style..

then, to paste Allen Wyatt's macros :

google "excel create vba macro"

To make this one start automatically when you open this workbook :

https://support.office.com/en-us/article/Run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155#bmrunmacroautomatically (resource)

(summary :)
You go to Visual Basic

Right click "This Worksheet". And add : (or overwrite) (you do need to read the stuff on above link :)

Private Sub Workbook_Open()
    Run "StartFlash"
End Sub

No comments: