calling a macro to run on several sheets at once
Posted by rm on December 24, 2001 10:47 AM
I am using macros to update several worksheets in a workbook. I simply record the keystrokes of the changes I need to make to the worksheets and then execute the macro on each worksheet. This works fine, but the workbooks have between 40-50 sheets each. I would like to know if there is a way to run the macro just once to update all of the worksheets instead of run the macro on each worksheet (thus having to run the macro 40-50 times) which is what I am currently doing. (Not that I am necessarily lazy, just a time saver.) Any help is much appreciated.
p.s. all of the worksheets in the workbooks are identical in regards to design and formulas--just the information the user inputs on the sheets is different (they are employee timecard records).