Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Finding elusive control on User Form | Excel Programming | |||
Finding CellRef for Control+Home | Excel Programming | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |