| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 105284 | 2009-11-25 22:47:00 | Save and Exit button in Excel Spreadsheet | asdex (1488) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 833571 | 2009-11-25 22:47:00 | Hi anyone know how to put a "Save and Exit" button or hyperlink in an Excel spreadsheet? I have a Spreadsheet with 10 workbooks and when people add information. I want to make it easy for them to remember to save the changes. I don't want to use a Macro as I get that warning message and the spreadsheet can be accessed from lots of computers. I don't want to have to set them all to the lower security level. Thanks. |
asdex (1488) | ||
| 833572 | 2009-11-27 20:24:00 | Having a button means you have a macro which appears you want to avoid because of the enable macros warning. When a workbook closes that has had changes Excel warns the user anyway so Im not sure why you think having a button is going to encourage people to save if they dont when they get asked to save when they close the workbook. If your wanting to enforce saving then a macro could do this automatically without asking the user. You can alternatively use whats called an Add-In which is a macro but loads when Excel starts so you dont get the enable macros warning. MS have an AutoSave macro ... support.microsoft.com Of course saving has drawbacks too. If you made a major mistake and decide you want to start again you could close without saving and start again. If autosave is enabled your mistakes are saved too. cheers, Graham |
Parry (5696) | ||
| 833573 | 2009-11-27 21:07:00 | Thanks very much, I'll see how that goes. Cheers |
asdex (1488) | ||
| 1 | |||||