XLM Macro Sheet in Excel 2010

[leonard522]

Hi,
I am trying to get a function defined in an old style Macro sheet accessible in Excel 2010. I used to have it in my personal.xls, but I cannot figure out how to add it in 2010. I think I will upgrade it to VBA but in the mean time, I would like to have it available in all my worksheets.
Thanks!
Jen

 

[Andrew Poulsom]

Welcome to the Board.

Do you get the option to insert one if you right click a sheet tab and choose Insert?

 

[leonard522]

Hi,
When I right click a tab, I do get the option to select MS Excel 4.0 Macro. So it seems they are still "allowed" in 2010. But how do I then save to my personal.xls?
Thanks!!

 

[Andrew Poulsom]

The same way as you put it into your PERSONAL.XLS before you upgraded. Unhide the workbook, insert a macro sheet and copy the code from wherever you have it.

 

[leonard522]

That worked! Thanks!!