Link two worksheets....
When you say a change is "saved" on a sheet what do you mean? Do you
mean when the cell contents are changed? If you mean when the workbook
is saved, you can use the BeforeSave event. Put this code in the
ThisWorkbook module.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
'your code goes here
End Sub
Mark
J.W. Aldridge wrote:
Need a code (one that triggers on save).
Whenever a change is saved on THIS sheet (in this workbook):
update the next available row on: another sheet in another workbook.
C:\Documents and
Settings\Administrator\Desktop\[master.request.xls]Sheet1
Is this possible?
|