| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Procedure for multiple sheets
Hi,
I have a procedure that formats Worksheet1 when something happens in a certain cell. Worksheet1 is titled: APPLES. The procedure I have for this works great. Working part of the procedure I have now looks like this: With Worksheets("APPLES") Hide rows, change font color etc. I would now also like to have the same thing happen in Worksheet2. Worksheet2 is called ORANGES. Something like: With Worksheets("APPLES & ORANGES").... Is is possible to have mutiple worksheets follow the same procedure? Thank you for your time, Amy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A macro code to print multiple sheets in different w.books | Excel Discussion (Misc queries) | |||
| Help on VBA Code to populate multiple sheets | Excel Discussion (Misc queries) | |||
| change code to work over multiple sheets | Excel Programming | |||
| Rename Multiple Sheets - Help with Mr Dave Peterson's Code | Excel Programming | |||
| Sort Sheets Procedure | Excel Programming | |||
Threaded Mode
