XL07 Open Macro to use Own Macros

[petermoran]

Hi,

I have a number of workbooks which contain their own macros.

I would like to have an Open macro which resets the Alt-F8 window so it shows just macros in "This Workbook" rather that all open workbooks.

Thus when I use Alt-F8, the window shows the macros I want to use.

And likewise when it closes, the situation reversed to use "All Open Workbooks" once again, if possible.

I have tried with recording a macro but got nowhere.

Any help greatly appreciated.

Regards,

Peter Moran

[HansV]

The Macros dialog is - for obvious reasons - not exposed in the Visual Basic Editor. It's possible to use SendKeys to display the macros dialog with macros from the active workbook only, but I assume that you don't want to display this dialog each time the workbook is opened. Moreover, SendKeys is notoriously wacky.

[petermoran]

Hi Hans,

Thanks for the reply.

I have noticed that once a workbook is opened and the Alt-F8 window is set it sticks until it is changed again, at least while Excel continues to be open.

I have previously come across problems with Sendkeys.

No easy solution, it appears!

Thanks again.

[HansV]

I'm afraid that there is no easy solution indeed. Sorry!