How to run macro for "private sub.."

[PA]

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

 

[Tim Williams]

Make it Public not Private, or create a new Public Sub which calls it.

Tim

 

[PA]

Dear JBeaucaire,

Do you mean there is no way to run that macro other than remove that word
"private" ?

Thanks alot

PA

 

[Gord Dibben]

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

 

[PA]

Dear All,

It does help

Thanks alot.

Best Regards

PA