Stopping Macro Excel 2003

[DanH84]

Hi,

I've got a 2003 workbook I'm editing in excel, I've got the password and removed protection but I'm a bit stuck with a macro it seems to run whenever the workbook opens.
All it is is a terms of use for the sheet that the user has to ok whenever they use it, however this terms of use mentions my old section and gives outdated policy references.

I'm using excel 2010 and have enabled the developer tab but can't see the macro in there. I can see ones it runs when it is open but not this one that it seems to run when opening.

My ideal would be to edit it to mention my new section and put the correct policy, but with my lack of knowledge I'll happily settle for just disabling it so it doesn't show up at all for other users. Does anyone have any ideas at all?

Cheers

 

[RavenLunatic]

Have you double clicked on the ThisWorkbook icon on the left hand side of the Visual basic editor? its in a window called vbaprojects

I would imagine the code is in there if the macro runs each time its opened.

look for one with a sub called workbook_open() or workbook_sheetactivate.

alternativily it might be a form which will be in a directory in the same window.

sub auto_open() can also run a macro when a spreadsheet is opened and can be inside a module.

 

[DanH84]

that worked a treat thanks