Run Macro continually on the active sheet

[barnetto]

Hi,

I want to run a macro continually on the active sheet. The active sheet would have been created previously by a different macro, so I'm unable to put the macro within the sheet itself. The Macro below works as expected when placed within a given sheet, but not when I move it to a module.

Please Login or Register  to view this content.

[barnetto]

I found a solution which was to create a template sheet with the macro embedded, then copy that template instead of creating a new blank sheet. This results in every new sheet having the macro embedded.