View Single Post
 
Old 06-20-2014, 10:56 PM
shilabrow shilabrow is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default 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.
Reply With Quote