run macro on workbook open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?
 
type in Workbookopen and click on search said:
Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?
Click to expand...
 
and then do the typing said:
Hi,

I have a macro that sorts a table. what do i need to do to have this macro
run every time the workbook is opened? is it simply run XYZ() under the
object this workbook?
Click to expand...
 
Almost:

Private Sub Workbook_Open()
Call XYZ
End Sub

in the ThisWorkbook module

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Workbooks using same macro 4
Macro to open seperate workbook 3
Macro to push data to another workbook 0
Merge Multiple workbook sheets into one workbook 0
Disable Macro Alert 2
How to call up a macro in a different location? 1
Macro to run when a particular sheet is opened 4
macro to display message,when open workbook 7

Back
Top