OnOpen Event for Excel Sheet.

I want to do a few particular things (coded in vba) whenever the spreadsheet is opened. The help area sites this code as an example:

Please Login or Register  to view this content.

If the paste this into a VBA macro (Toold Macro)in Excel and run it; it works fine. When I close the book and reopen though...nothing happens. In other words it is NOT performing my code onopen. Do I need to stick Workbook_open() in a certaiin spot? Is that a reserved term? Help!!!

Hi,

Please read forum rules below. Code needs to be wrapped in future

The code goes in Thisworkbook

See link

http://www.contextures.com/xlvba01.html#Workbook

VBA Noob