Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using worksheet_change
I have successfuly implemented worksheet_change to perform some actions
(clearcontents on various ranges) on the worksheet in question. However, when I attempted to perform the same actions in ANOTHER worksheet, based on the same event, the code halted. I suspect that worksheet_change can't launch actions in other sheets, but I am not sure. In the end, I am trying to find a way to launch actions on this other worksheet...biggest barrier is that nothing changes on that other worksheet itself, all changes are the results of formulas linked to the original cell that is changing. For example...is there a workbook_change feature that would allow it? I cannot find any syntax references anywheere... Thanks for any help, Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using worksheet_change
In the thisworkbook module:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) End Sub -- Regards, Tom Ogilvy "Tom Mackay" wrote: I have successfuly implemented worksheet_change to perform some actions (clearcontents on various ranges) on the worksheet in question. However, when I attempted to perform the same actions in ANOTHER worksheet, based on the same event, the code halted. I suspect that worksheet_change can't launch actions in other sheets, but I am not sure. In the end, I am trying to find a way to launch actions on this other worksheet...biggest barrier is that nothing changes on that other worksheet itself, all changes are the results of formulas linked to the original cell that is changing. For example...is there a workbook_change feature that would allow it? I cannot find any syntax references anywheere... Thanks for any help, Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using worksheet_change
Worked perfectly...thanks for the assistance, this site is so helpful to
non-programmers lime me trying to get by. "Tom Ogilvy" wrote: In the thisworkbook module: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) End Sub -- Regards, Tom Ogilvy "Tom Mackay" wrote: I have successfuly implemented worksheet_change to perform some actions (clearcontents on various ranges) on the worksheet in question. However, when I attempted to perform the same actions in ANOTHER worksheet, based on the same event, the code halted. I suspect that worksheet_change can't launch actions in other sheets, but I am not sure. In the end, I am trying to find a way to launch actions on this other worksheet...biggest barrier is that nothing changes on that other worksheet itself, all changes are the results of formulas linked to the original cell that is changing. For example...is there a workbook_change feature that would allow it? I cannot find any syntax references anywheere... Thanks for any help, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_change | Excel Programming | |||
More Then one Worksheet_Change | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |