Event macro error when opening workbook

Closed
wgirl Posts 1 Registration date Wednesday 10 March 2010 Status Member Last seen 10 March 2010 - 10 Mar 2010 à 15:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 Mar 2010 à 18:30
Hello,

I am a newbie excel visual basic program dabbler. I have created a macro that runs several other macros just fine when I run it myself. I have been attempting to set this macro up to run automatically when the workbook is open. I am using excel 2004 for Mac. I go under tools, macro, visual basic editor and then in the Projects window under Objects select this worksheet. Then under the workbook tab I put this code:

Private Sub Workbook_Open()
AllBilling
End Sub

The macro AllBilling is under the modules folder. I can not figure out for the life of me what the problem is here. I get the compile error: expected variable, procedure, not module. This may be really simple, but again I am so very green and teaching myself. Beating head up against wall for two days. Can anyone help me?
J

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Mar 2010 à 18:30
Is AllBilling a public routine ? Private will not work since its not visible out side that module