um... me too. but i think if you just turn on the macro recorder (tools menu>macros>record new macro), follow the directions for naming, etc, then turn off the recorder again, press alt+f11 and paste the code in to the macro you have created, it should work. i really should do some reading on this stuff one day...
hmm, let's see... sorry about this - vba's not really my bag. from looking at the vba editor, the default is to record the macro in 'sheet 1', which you'll see if you look at the icons in the area called 'project - vba project' on the top left of the screen. i think you'll have to cut and paste the code to the 'this workbook' page. i'm really guessing here though - the vba heads on this board are probably rolling 'round the floor laughing by now...
Press ALT & F11 to open the VBA screen. On the left hand side there should be a screen titled Project-VBAProject.
If this is not visible select view, Project Explorer or CRT R You will see a heading VBAProject followed by your file name in brackets.
Expand this and expand the folder Microsoft Excel Objects. You will see all your sheets and "ThisWorkbook"
Double click on ThisWorkbook it will open a screen to place your code. Or right click and select view code
This is where you need to place the macro suggested. It is a workbook event macro.
There are two drop down boxes at the top of this screen. Select the first one and it will show the options (general) and Workbook. Select Workbook. In the second dropdown box you will see a list of events that you can add code to make things happen.
Each sheet also has similar dropdown boxes of events that can be coded.
Next select insert, Module this will create a blank module where you will place the macros you write or macros that you record using the macro recorder.
Best advice I can give you is Play the recorder it is a great learning tool. Read the help files, and use the object browser it is one of the buttons on your VBA toolbar. search the archives here for help there is tons of knowledge if you look for it. And keep posting if you are stuck