WHERE TO FIND PERSONAL MACROWORKBOOK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to record a macro in personal workbook.The errors says that pls
find the personal macroworkbook in the startup folder..How to find the same.
As i dont want to record macros in the workbook where the working is being
done, i wanted to record macro separately.Pls share if you could know any
wayout.
 
Hi Satish,

If you do not already have a personal.xls workbook one will be
created for you in your XLSTART directory. When you record
your macro change the dropdown box to record in "Personal Macro Workbook"

Under tools, Options, General the area marked
Alternate Startup Location should be empty.

You can find the actual pathname afterwards by searching
on personal.xls which you will find in your XLSTART directory.
 
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

Cannot find Personal Macro Workbook 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Vista problem with NO Personal Macro Workbook in Startup Folder 6
Personal Macro Workbook in startup folder missing 3
Personal Macro 1
Excel VBA to update OLE Linked files in PPT 7
Personal Macro Workbook 1
MACROS 1

Back
Top