Transfer Macros across Workbook

[Noz2k]

I have a macro which saves a worksheet as a sheet in a new workbook, on a button click.

On that sheet however there are a couple of other buttons which do various other things such as Print the sheet, Copy part of the sheet, which I would like to still work in the newly created workbook.

Is there a way of doing this?

 

[VoG]

This may help you http://www.cpearson.com/excel/VBE.aspx

 

[Noz2k]

Thanks,

Looks pretty complex, think I might give it a miss seeing as it won't add too much benefit to my project really.

Thanks anyway, when I get a bit more practiced at VBA and need to do something similar I may give it a go.

 

[Noz2k]

As it turns out it was a really simple solution to my problem. As the macros I needed to work only referenced things within the sheet that was saved, I just copied the sub procedures from the modules into the worksheet module.

So when the worksheet was copied over to the new workbook, all the procedures were transferred along with it.

It just meant I had to use ActiveX control buttons to call the modules instead of form control buttons