Workbooks can live in the the workbook in which they are created.

If that workbook is not open you won't see the macros.

Or macros can be in your Personal.xls, in which case they would be seen no
matter which workbook(s) are open.

Maybe you previously had a Personal.xls but now have not?

The macros could also be in an Add-in.

In that case they are never visible in ToolsMacroMacros


Gord


On Thu, 15 Jan 2009 04:26:09 -0800, Dudley
wrote:

Thanks to both of you for your advice. I do use 'All open workbooks'.

I did Alt/F11 and found some of the macros with difficulty, but the one I
wanted was not there. I finally found it when I tried to run it and it gave
an error message and allowed me to edit it.

It seems that macros are linked to specified workbooks, presumably the one
open when I created the macro, and I can only view the code when that
workbook is open, although previously I have viewed all macros to edit them
without any problem.

Dudley

"Gord Dibben" wrote:

Maybe you also changed ToolsMacroMacros "Macros in:" to a workbook that
has no macros.

Mine is generally set to "All open workbooks"


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 09:38:04 -0800, Dudley
wrote:

I have macros on a toolbar in Excel 2002 and I want to change one of them. I
do this by going into Macros, selecting the one I want to change, and
clicking 'Edit', but now the list of macros has disappeared. Can anyone
advise how I can get the list back? The macros are still working.

Thanks
Dudley