Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing Worksheet SAVE
Hi
does anyone know how to bypass the save function when you close down excel? I have a spreadsheet which has a programmed button which writes out text to a file so the cell contents of the spreadsheet don't need to be saved, but of course everytime the sheet is used excel senses a change and therefore prompts the user to save the spreadsheet. I would like to bypass the 2nd save request as users think they've already saved the data (which they have). My intention is to include something in the programmed save along the lines: application.autosave = false but I don't know which property I should be using. Thanks in advance for any responses. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing Worksheet SAVE
Try one of
Activeworkook.saved = tru Activeworkbook.close SaveChanges:=false |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing Worksheet SAVE
Activeworkbook.close false
will close the workbook and not prompt to be saved. and activeworkbook.Saved =true will make Excel think that the workbook has been saved. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Peter" wrote in message ... Hi does anyone know how to bypass the save function when you close down excel? I have a spreadsheet which has a programmed button which writes out text to a file so the cell contents of the spreadsheet don't need to be saved, but of course everytime the sheet is used excel senses a change and therefore prompts the user to save the spreadsheet. I would like to bypass the 2nd save request as users think they've already saved the data (which they have). My intention is to include something in the programmed save along the lines: application.autosave = false but I don't know which property I should be using. Thanks in advance for any responses. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypassing a proxy server | Excel Discussion (Misc queries) | |||
Bypassing ENABLE/DISABLE MACROS message | Excel Discussion (Misc queries) | |||
Bypassing the 128MB formula memory limitation in 2002? | Excel Discussion (Misc queries) | |||
Bypassing password | Excel Programming | |||
Bypassing Protections | Excel Programming |