finding control
 

OK,
This seems like a dumb question.
I have inherited some code. Some of the sheets have:
Private Sub <xxx_Click()

However I do not think it is being used. I am looking for some kind of
control.
I go to the page. On the properties window, I only see the sheet4. Nothing
else.

On the page I do not see any controls.
Is there any way I can tell where this code can be connected to?
Anything else I can look for/at?

finding control
 

I f you right click on the sheet name tab and select view code, it opens the
code window for that sheet. If you then click in the small window at the top
left of the code pane where is says General and select worksheet, VBA
automatically puts two lines of code in the code window. Apparently, someone
has done this process before and did not bother to delete it. If there is
nothing but the Sub and End Sub lines, it can be deleted or left alone. It
does nothing and affects nothing. However, if there is code between those
two lines, you should either consult with someone in your office or post the
code here for comments on what it is supposed to do before you delete it.

"greg" wrote:

OK,
This seems like a dumb question.
I have inherited some code. Some of the sheets have:
Private Sub <xxx_Click()

However I do not think it is being used. I am looking for some kind of
control.
I go to the page. On the properties window, I only see the sheet4. Nothing
else.

On the page I do not see any controls.
Is there any way I can tell where this code can be connected to?
Anything else I can look for/at?