| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you force excel to save on close
Having trouble with an excel user not saving an excel document even if she is
prompted to. Is there anyway you can set an excel file up to save as its closed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you force excel to save on close
Try to place a
Thisworkbook.Save line in the BeforeClose event procedure! Regards, Stefi €˛Tom Hewitt€¯ ezt Ć*rta: Having trouble with an excel user not saving an excel document even if she is prompted to. Is there anyway you can set an excel file up to save as its closed. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you force excel to save on close
Thank you. Works like a charm.
"Stefi" wrote: Try to place a Thisworkbook.Save line in the BeforeClose event procedure! Regards, Stefi €˛Tom Hewitt€¯ ezt Ć*rta: Having trouble with an excel user not saving an excel document even if she is prompted to. Is there anyway you can set an excel file up to save as its closed. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you force excel to save on close
You are welcome! Thanks for the feedback!
Stefi €˛Tom Hewitt€¯ ezt Ć*rta: Thank you. Works like a charm. "Stefi" wrote: Try to place a Thisworkbook.Save line in the BeforeClose event procedure! Regards, Stefi €˛Tom Hewitt€¯ ezt Ć*rta: Having trouble with an excel user not saving an excel document even if she is prompted to. Is there anyway you can set an excel file up to save as its closed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Is there a way to force Excel to close workbooks independently? | Excel Discussion (Misc queries) | |||
| force excel to run in only one process excel.exe | Excel Worksheet Functions | |||
| Save? prompt when closing Excel | Excel Discussion (Misc queries) | |||
Linear Mode
