Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto save feature (not auto recovery) | Excel Discussion (Misc queries) | |||
Excel 2007 auto-recovery / auto-save? | Setting up and Configuration of Excel | |||
Auto save | Excel Discussion (Misc queries) | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
Auto Excel workbook close: save= false during an auto subroutine | Excel Programming |