Copy a worksheet macro into the PERSONAL.XLS file

[Bagharmin]

I just wrote a brief procedure in a spreadsheet. Now I want to send it (import it?) to my PERSONAL.XLS file. How do I do that?

Thanks.

 

[cstimart]

You can just copy/paste from it's source to the appropriate module in Personal.xls

 

[Bagharmin]

Perfect. Thank you very much.

 

[Bagharmin]

Well, it appears I still need some more help. I inserted a module into PERSONAL.XLS and copied my code into the new module and saved the changes to the PERSONAL.XLS file. Now I'm trying to add an icon in the Quick Access Toolbar so I can run this whenever. I chose commands from Macros, but my module (Module4) isn't listed as an option. What else do I need to do in order to add this to the Quick Access Toolbar as an icon?

 

[cstimart]

Well, it appears I still need some more help. I inserted a module into PERSONAL.XLS and copied my code into the new module and saved the changes to the PERSONAL.XLS file. Now I'm trying to add an icon in the Quick Access Toolbar so I can run this whenever. I chose commands from Macros, but my module (Module4) isn't listed as an option. What else do I need to do in order to add this to the Quick Access Toolbar as an icon?

Did you save and close excel and then reopen?

 

[Bagharmin]

Yeah, I did. I started by selecting VBAProject(PERSONAL.XLS) and inserting a module. Then I took my code and copied it to the new module. I tried to add the icon, but the module I wanted didn't show. So I closed Excel and saved the changes to the Personal Macro Workbook. I got back into Excel and tried to add the icon, but the macro still wasn't showing. I even renamed it from the default of Module4 and tried again, but it didn't show. I either have more steps to take before I can add the icon or I left something out earlier.

Thanks for helping with this.