assign a button to these macros and put the button on every sheet. Else if
the macro is written as seperate module you can insert it directly in the
worksheet. You can even assign a shortcut key. It's in toolsmacro

"Biti" wrote:

I have a macro that cleans up data types on activate. Once the macro
run on activate then the chart on the first worksheet works fine. But
until the macro gets activated nothing happen on the first worksheet.
There is 7 worksheet and I have this macro execute on each one of the
worksheet. How would I execute this macro the first time the
worksheet is opened? If the user choose to pick any of the worksheet,
I would like the macro to run for all of them. Regardless of which
worksheet is activated. What is the simplest way of doing this? Any
idea is appreciated

Biti