How to run macro for "private sub.."
 

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

How to run macro for "private sub.."
 

Private means "For Excel to use, not users" so you would need to change
the name of the macro to make it user-accessible.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46879

How to run macro for "private sub.."
 

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

Tim

"JBeaucaire" wrote in message
...

Private means "For Excel to use, not users" so you would need to change
the name of the macro to make it user-accessible.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46879

How to run macro for "private sub.."
 

Dear JBeaucaire,

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

Thanks alot

PA


"JBeaucaire" wrote:


Private means "For Excel to use, not users" so you would need to change
the name of the macro to make it user-accessible.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46879

How to run macro for "private sub.."
 

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

How to run macro for "private sub.."
 

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