Auto run code on workbook opening

[eti3nne]

I have a command button on one sheet of a workbook which causes some sorting and other activities when clicked.

I need to get the code to run once when I first load/open the workbook. I have tried setting the AutoLoad property of the command button to true, but this does not seem to do anything.

Any ideas how/where I could get this to work?

Thanks for looking.

 

[combo]

In VBE display workbook's module (double-click ThisWorkbook icon in project explirer window), from the left drop-down list choose Workbook (default: General), you should see 'Open' in the right drop-down.

combo