VBA Macros to follow a Excel worksheet being moved from workbook? 1

[RyanScharfy]

I have some macros that play with the page breaks and column grouping associated with some radial buttons on a worksheet.

I'd can move that worksheet out of the workbook but the macros are then lost.

Any easy fix for this?

 

[DirkStruan]

Have you tried storing the macros under the sheet module (General drop down rather than Worksheet as you won't be working with Events)? They should then be portable.


Dirk

Everything useful perishes through use....Should I not rejoice at being useless?

 

[RyanScharfy]

Thank you Dirk. So simple, yet I had no clue. The story of my life.