Can anyone tell me how to run a macro each time a worksheet is activated?
R Roger Palmer May 18, 2005 #1 Can anyone tell me how to run a macro each time a worksheet is activated?
J Jim Gordon MVP May 18, 2005 #2 Hi, Yes, in the visual basic editor click the search help button and search on the word events "Events" are triggers that you can use to run macros. The help topic of most interest will be Using Events with Microsoft Excel Objects -Jim
Hi, Yes, in the visual basic editor click the search help button and search on the word events "Events" are triggers that you can use to run macros. The help topic of most interest will be Using Events with Microsoft Excel Objects -Jim
