Auto Save
 

In This file I've inherited, whenever I click save, it seems to return to a certain worksheet, one which I plan to delete!

I can't seem to find where this is happening. Would it be within the This Workbook object, or could it be elsewhere. I see a macro for closing, but not one for saving. Any guesses where I might find it?

Thanks!
Dean

Auto Save
 

Look in the code for "ThisWorkBook" and you most likely will find a piece of code in the workbook save event

e.g.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

' some code in here <<<<<<<<

End Sub

--
Cheers
Nigel



"Dean" wrote in message ...
In This file I've inherited, whenever I click save, it seems to return to a certain worksheet, one which I plan to delete!

I can't seem to find where this is happening. Would it be within the This Workbook object, or could it be elsewhere. I see a macro for closing, but not one for saving. Any guesses where I might find it?

Thanks!
Dean