Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel .EnableEvents Worksheet Function

Status
Not open for further replies.

BruceMutton

Geotechnical
Sep 4, 2001
15

thread766-11466 contains the full text of my question, however it commences as follows...

Hi all
I have written a simple user defined function to make it apparent on the worksheet when events are no longer being triggered. (I have an iterative solver type routine that is triggered by the calculate event, rather than using an on sheet button)

In a worksheet cell, I would enter something like;

=IF(bEvents(),"OK","Events are disabled")
Continued in thread766-11466 ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor