Embedding a macro

[SteveO27]

Hi,

I have recorded a macro & added a button onto the spreadsheet which works fine when I run it on my pc. However, as the macro is saved on my pc & not embedded into the spreadsheet it doesn't work when I email the spreadsheet. Can anyone please tell me how I can fix this?

Cheers

Steve

 

[number kruncher]

When you recorded the macro, did you save it your personal.xls file?

If so, use Alt + F11 to open VBA window, find the personal.xls file and copy the macro, then highlight your workbook name and insert module, paste macro in to this.

HTH

P.S. Welcome to the board.

 

[SteveO27]

That's worked a treat - simple when you know how! Thanks very much for your help.

Steve

 

[number kruncher]

Most welcome.

Thanks for the feedback.