Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Forcing save on shared doccument
Is there a way to code the macro so that any time a user makes a change (and deselects the cell) the file will save? I'm trying to make a sort of live updating shared document.
Thanks, Pistolade |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing save on shared doccument
Pistolade wrote:
Is there a way to code the macro so that any time a user makes a change (and deselects the cell) the file will save? I'm trying to make a sort of live updating shared document. Put this in the workbook's ThisWorkbook pbject: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Me.Save End Sub AFAIK this will only fire when the *contents* of a cell are changed. Things like formatting changes (bold, italics, fonts, etc.) will *not* fire this event. -- These hands! I can't get them off my wrists! Oh, God! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing save on shared doccument
Pistolade wrote:
Is there a way to code the macro so that any time a user makes a change (and deselects the cell) the file will save? I'm trying to make a sort of live updating shared document. Put this in the workbook's ThisWorkbook pbject: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Me.Save End Sub AFAIK this will only fire when the *contents* of a cell are changed. Things like formatting changes (bold, italics, fonts, etc.) will *not* fire this event. True so long as the formatting isn't done via RTF feature in EditMode! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Rows with values in column A pasting in a new doccument and saving that doc | Excel Discussion (Misc queries) | |||
how do I delete documents from the recent doccument box(excel) | Excel Discussion (Misc queries) | |||
Forcing Save as in the format of Excel 2007 | Excel Discussion (Misc queries) | |||
Keeping Margins and Forcing Landscape mode on a shared Document | Excel Discussion (Misc queries) | |||
Forcing Save As: dialog box | Excel Programming |