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.

--

HTH

RP

"Peter Chatterton" wrote in message
. ..
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