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:
Post a Comment