How create a new Project in VBA

  • Thread starter Thread starter LiveUser
  • Start date Start date
L

LiveUser

I somehow lost me Personal Macro collection. I am wondering how to create a
new project so I can name it and start creating modules.

Thank you.
 
hi
just name a standard xl file as personal.xls and start dumping modules in
it. save it the the xl start up folder. and create a back up for it.

regards
FSt1
 
Tools>Macro>Record New Macro>Store Macro In>Personal Macro Workbook

Record anything and stop recording. You now have a Personal.xls


Gord Dibben MS Excel MVP
 
Gord Dibben,

Surprising to me, that would not work, !at the time!. I don't know why and
since i created my new personal project my old personal project appeared...
weird.
 
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

Excel VBA - counting cells by colors and names to it in two different rows. 0
How to create a bubble chart with more than 2 variables 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Can Vba workout if a selection is part of a group? 0
How do I remove VBA projects in Excel 4
How do I invoice a cost to a custom built MS Access Accounting Database? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Setting up TrueNAS frustration 4

Back
Top