| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
having a macro work only on a worksheet
I have a simple sub to highlight some cells, is there anyway to make this run on only sheet 1 but not sheet 2 and 3 in a workbook when I press Ctrl+g?
Thanks, Example Sub macro1( ' Keyboard Shortcut: Ctrl+ Range("A1:B1").Selec With Selection.Interio .ColorIndex = .Pattern = xlSoli End Wit End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link one worksheet in a workbook to another worksheet in same work | Excel Discussion (Misc queries) | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| Retrieving data into worksheet from another worksheet in same work | Excel Discussion (Misc queries) | |||
| Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
| Macro works Macro does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
