|
|
#1
06-20-2014, 10:56 PM
|
|||
|
|||
How To make any open sheet in WorkBK run Macro.
I recorded a macro in Sheet 1 and I have about 3 Sheets in the workbook. But I notice that I have to open Worksheet 1 for the macro to run else I get error. What can I do to make sure that once the workbook is open regardless of which sheet am in, my macro chosen will still run and execute properly. All help appreciated! Thanks much.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to make an add-in/global macro
|
hanvyj | Excel Programming | 4 | 12-14-2012 03:23 AM |
| Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |
| confirmation popup on excel sheet macro | mark-gabb | Excel Programming | 3 | 12-22-2011 01:16 AM |
| Debug for macro run through button only when sheet protected | leahca | Excel Programming | 0 | 11-24-2011 04:47 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows Vista 
Office 2007
Threaded Mode