Thanks
I was obviously trying to do as Fst1 suggested in the wrong place. Once in
the right area it worked.
--
Jimmy


"Gord Dibben" wrote:

Jimmy

Might be easier to go back to the Excel window and right-click on the Excel Icon
left of "File"

Select "View code"

From left drop-down select "Workbook".

This will appear

Private Sub Workbook_Open()

End Sub

Then from right drop-down select "BeforeClose" and this will appear

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub

Add your macroname like so...............

Private Sub Workbook_BeforeClose(Cancel As Boolean)
macroname
End Sub

Delete the workbook_open and its end sub.


Gord Dibben MS Excel MVP



On Wed, 21 Nov 2007 17:04:45 -0800 (PST), carlo wrote:

Unsure of what you are trying to do. Have tried to follow in vb but am not
able to work out where you are. I am working with excel 97 (possibly a bit of
a dinosaur) but is all I have.
Do I maybe have to start a new vb macro to do this? or can it be done with
the existing macro?
My left drop down only contains (General) and the right has the macro name
and (Declarations)