Calling the workbook_open sub

How do call the workbook_open sub from one of the worksheet modules or from a new module?
LVL 43
Saqib Husain, SyedEngineerAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
First, change it to a Public sub. Then call it:

    ThisWorkbook.Workbook_Open

Kevin
0
 
Rory ArchibaldCommented:
Or use:
   Application.Run "'" & ThisWorkbook.Name & "'!thisworkbook.workbook_open"

Open in new window

and leave it private. Or better still, move the code to a regular module and call it from both locations. ;)
0
 
Saqib Husain, SyedEngineerAuthor Commented:
Kevin,
Great, thanks. Just what I was looking for.

Rory,
Good to know, thanks.

Saqib
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.