personl.xls (storage of VBA-Code)

  • Thread starter Thread starter Walter-U. Kellner
  • Start date Start date
W

Walter-U. Kellner

Hello everybody,

I had you reinstall EXCEL and can't find the place any more, where I define
the storage place for VBA-code and macro-code. I'd like to put everything in
personl.xls, but where can I turn that option on?

thanks for your help!
Walter
 
You have to create personal.xls first, you can just record a dummy macro and
select personal macro workbook instead of this workbook, just start and stop
the macro, then delete all the code recorded and oput in your macros there
(press alt + F11 to open the VBA editor and select the personal from the
project pane, double click module 1)


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime Error 1004 1
Word to Excel: Export comments with text and line number 0
vba powerpoint pasting named shape in selected named slides 0
NVME Storage Drives 8
Importing any excel files with any sheet name into different tables in MSAccess using code 0
VBA code, value in a range 3
Can Vba workout if a selection is part of a group? 0
vba macro that allows insertion of symbols at cursor 0

Back
Top