Dear All,

It does help

Thanks alot.

Best Regards

PA
"Gord Dibben" wrote:

It is not meant to be run manually. It is event code that runs when the
workbook oipens.

It is meant to be placed in Thisworkbook module.


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 19:29:01 -0800, PA wrote:

Dear All,

I try to run this macro :

For example:

Private Sub Workbook_Open()
Msgbox "Hello"
End Sub

But I can not see the macro name at all at macro dialog box (Tol--Macro--..)

Is there any way that I need to do enable me to run this macro without
delete the word"private"? eg via macro button or shorcut as usual

many thanks for your advise

PA