Problem Organizing Macros under XP

  • Thread starter Thread starter Peter Chatterton
  • Start date Start date
P

Peter Chatterton

I want to put various sub's in Personal,
but can't find it. In the Excel windows
Unhide is greyed out.

Also, I've got several workbooks open,
and if I do alt-F8 to show the macros,
and if I specify 'macros in all open wb's'
then why don't they all look the same?
e.g. I've just created a Sub Common
but it's only visible in one of the wb's,
presumably the one I created it in.

Hope you can help,
Peter
 
Peter,

It sounds that you don't have a Personal.xls.

Record a simple macro, and when when you get the dialog box, make sure that
you select Personal Macro workbook from the Store In dropdown.
 
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

Error message 1004 2
closing another file by code causes failure to run workbook activate event 2
Activate workbook using partial name 5
automatic replacing of vbe code for multiple workbooks 1
help with VBA program to import and add formatted files to one file 0
2003 created Workbook casuses error when macro runs in 2007 2
Implement a progress bar when the macro run inside another workboo 2
Macro Question 2

Back
Top