VBA Macros to follow Excel worksheet being moved from workbook?

[RyanScharfy]

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

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

Any easy fix for this?

 

[SkipVought]

Copy the macro code to the worksheet object of the sheet you are moving out of the workbook.

Or with the original workbook open along with the NEW workbook containing your sheet, drag the module containing the code to the other workbook in the VBA Project Explorer (ctr+R to VIEW)

Skip,

_[red][/red]

 

[RyanScharfy]

Skip,

Can I throw a curve ball here? The worksheet is moved as part of the instructions of a macro. Users wil press a button and "voila" they get the report. The users won't know how nor will want to manually do it.

That being said, I hope I'm not completely out of luck. Any idea? Is it possible to write a macro that "writes a macro"? I suppose anything's possible, but can get complicated. If you could point me in the right direction, it might help. Thanks.

 

[Gavona]

Skips first suggestion will make the code move with the worksheet.


Gavin