Is there a do not call function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pokdbz - 27 Dec 2007 15:52 GMT

For some reason a function is calling this:
Worksheet_SelectionChange(ByVal Target As Range)

I don't want it to call this function. Is there a way to make it so it
doesn't call this function if there is a selection change?

Reply to this Message

Ron Coderre - 27 Dec 2007 15:55 GMT

In the Sheet Module containing the code:
Either
1) comment out that event code
or
2) delete it

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> For some reason a function is calling this:
> Worksheet_SelectionChange(ByVal Target As Range)
>
> I don't want it to call this function. Is there a way to make it so it
> doesn't call this function if there is a selection change?

Reply to this Message

Chip Pearson - 27 Dec 2007 16:00 GMT

Excel will automatically call the Worksheet_SelectionChange procedure when
the selection is changed (e.g., by clicking on a cell) either manually or by
other code. You can prevent event procedures from running with the
Application.EnableEvents property.

Application.EnableEvents = False
'
' your code here
'
Application.EnableEvents = True

However, it is very rarely required that you Select anything when working
with VBA. Instead, you can reference a range directly. For example,

Instead of
Range("A10").Select
Selection.Font.Bold = True

Use
Range("A10").Font.Bold = True

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

Reply to this Message