Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run on openinng worksheet
Does anyone know how to make a macro run automatically
when you open a worksheet, and not have to rely on hitting a button or a shortcut key? I want the sheet to flash a couple of times, so this is the code: ' Keyboard Shortcut: Ctrl+y ' Cells.Select With Selection.Interior .ColorIndex = 1 .Pattern = xlSolid End With Cells.Select Selection.Interior.ColorIndex = xlNone Range("A1").Select Cells.Select With Selection.Interior .ColorIndex = 1 .Pattern = xlSolid End With Cells.Select Selection.Interior.ColorIndex = xlNone Range("A1").Select Cells.Select With Selection.Interior .ColorIndex = 1 .Pattern = xlSolid End With Cells.Select Selection.Interior.ColorIndex = xlNone Range("A1").Select Cells.Select With Selection.Interior .ColorIndex = 1 .Pattern = xlSolid End With Cells.Select Selection.Interior.ColorIndex = xlNone Range("A1").Select End Sub Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
macro to apply worksheet event to active worksheet | Excel Programming | |||
Record Worksheet Content as Macro and Execute from another Worksheet | Excel Programming |