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.
|