Remove On Activate Sheet Event
Matthew,
Thanks for the suggestion. When I double-click on the worksheet, I get
two tabs.. one identified as "general" is blank (no code) while the
other identified as "worksheet" has the following code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
over to the right is a selection of possible events. When I click on
Activate, it creates the code
Private Sub Worksheet_Activate()
End Sub
The action of the workbook is the same whether or not this code is
present. Is there somewhere else where action on this event could be
specified? I am currently using Excel 2003, but I believe the sheet
was originally created in Excel 1997.
Paul writes
"Double-Click on 'ThisWorkbook". You'll probably find the calling
code
there."
There are a lot of properties, but none that seems to correspond to
what I am looking for.
Just to clarify, I know where the codes that gets called is... I just
want to stop the sheet from calling that code. Mainly it is a problem
when I am debugging and jumping from sheet to sheet because I get
error messages saying it cannot process the "OnActivateSheet" macro
while in DeBug mode.
Thanks again, for the help.
...Rick
On May 7, 1:20*pm, Matthew Pfluger
wrote:
You are close. *If you press Ctrl+R to bring up the Project Explorer, scroll
through the list until you find your project. *Expand the [+] sign next to
the name, and you'll see some folders. *One will be called "Microsoft Excel
Objects"; click the [+] to expand that folder. *You'll see objects for each
worksheet in the workbook and one object representing the workbook itself. *
Worksheet events are stored in these special code modules. *Simply double
click on the object that represents the worksheet you are working in. *Then,
find and delete all macros (events).
HTH,
Matthew Pfluger
"rcl2884" wrote:
I have an Excel workbook that I inherited that wants to run an event
every time I activate or deactivate a sheet. I cannot seem to locate
the worksheet events so that I can disable this. There are two
subroutines with names like "OnActivateSheetName" and
"OnDeactivateSheetName". If I simply remove these routines I get a
message that says that these subroutines cannot be found, whenever I
activate (or deactivate) the sheet.
How do I remove this "event" requirement?
Thanks,
Rick- Hide quoted text -
- Show quoted text -
|