Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Calculate problem
I have a worksheet_calculate event. This event is fired when I open another
sheet which does not have any events (or even a new sheet). The problem is that when the new sheet opens, it gives an error saying that this_particular sheet is not found. It is obviously looking for this_particular sheet in the new opened sheet. How to avoid this. I am looking for a code like: Private Sub Worksheet_Calculate() If Me.Name < Range("S2") Then Exit Sub where Range("S2") has the filename of the original sheet where the above event resides. The above checks for the sheetname, but I need the workbook name. I need something like Workbook.Name -- - Mangesh ------------------------------------------ Office XP & Windows XP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet_calculate code | Excel Discussion (Misc queries) | |||
worksheet_calculate | Excel Discussion (Misc queries) | |||
worksheet_calculate | Excel Discussion (Misc queries) | |||
Worksheet_Calculate event problem | Excel Programming | |||
worksheet_calculate **help** | Excel Programming |