Disappearing macros

  • Thread starter Thread starter diane
  • Start date Start date
D

diane

I have a user who has successfully recorded some simple
macros and saved them to the Personal Macro file. the
macros have worked up till now. They have now disappeared
from the macro list. Tools, macro, macros produces a blank
list.

I tried to find the macros by unhiding the personal book
but the unhide option was greyed out - Personal wasn't in
the Windows file list though and we couldn't display it in
any other way.

I thought that it may have been overwritten so tried to
create another one. I got a message to say that it was
already open, went to the Windows menu and the unhide
option was active. and I could then unhide the personal
workbook ok but still nothing was displayed in the macros
menu

I recorded a macro on the same workbook and assigned it to
a shortcut key, saved it to the Personal macro workbook -
the macro ran ok but again did not display in the macro
list.

I can't figure out why the macros don't display in the
list and it seems that they are deleted when the machine
is shut down.

Has anybody got any ideas please?
Diane
 
Diane,

One possibility: In the Macro dialog box, make sure that the "Macros In"
combobox below the macro list is set to "All Workbooks" or "Personal.xls",
not "This Workbook".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I've tried that thanks - any other ideas?
-----Original Message-----
Diane,

One possibility: In the Macro dialog box, make sure that the "Macros In"
combobox below the macro list is set to "All Workbooks" or "Personal.xls",
not "This Workbook".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)






.
Click to expand...
 
Back
Top