| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I set up an excel spreadsheet to update every time a user .
For some reason I cannot remember how to do this...
I want my spreadsheet to update (retain the changes that other users make) automatically. How do I do this? Help! JM |
|
#2
|
|||
|
|||
|
Jennie, are you talking about saving the workbook when it is closed? if so
put this in the thisworkbook code, if the user enables macros the file will save all changes before it closes Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Jennie" wrote in message ... For some reason I cannot remember how to do this... I want my spreadsheet to update (retain the changes that other users make) automatically. How do I do this? Help! JM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Auto Formatting an Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
| How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Linear Mode
