Just getting started

[sdelacey]

Hello All

I am new to the group and I have just started to learn VBA. I am sorry to ask such a simple question, but could you help.

When you record a macro in excel you have the choice of saving it in the worksheet or in your personal workbook where you can use the code in other spreadsheets.

When you create a macro in the VBA editor, how do you save it in your personal workbook so the code can be used in all the spreadsheets if required.

Thank you

Steph

 

[bryanbayfield]

personal.xls isn't always visible in the project explorer window, I guess this is your problem.

I go back into Excel, record a macro in teh personal workbook, then immediately stop it. Back into VB Editor, click on the personal.xls and remove teh shell of teh macro that you've just generated.

 

[SkipVought]

Hi,

1. turn on your Macro Recorder and select - save to Personal.xls

2. go to the VBA Project Explorer (alt+F11 Ctrl+R)

VOLA - a Personal.xls workbook!



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com