Macros Help

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

Guest

For some reason my marcos keep disapearing. I need to go click on my
personal.xls then they're available, but as soon as I close excel, then
reopen, their gone and I have to go click on the personal.xls file again.
I know I've had this issue before but seems like I just hid that file and
all was good this time it doesn't seem to be working.
Any ideas?

Thanks
 
Make sure you're putting personal.xls in a folder that excel will inspect when
it starts.

I like to find that folder this way:

Open excel
hit alt-f8 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter:
?application.startuppath

Make a note of it and store your personal.xls in that folder.
 
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

Macro Will Not Save 2
personal.xls 2
Personal.xls 5
change default to xlsx 1
Macros Available without hiding 'personal.xls'? 3
Macro Pause for selecting cell 3
Personal.xls will not open when I open excel 2
Book2 on open; click on X's twice to close Excel 2007? 0

Back
Top