Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default 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?




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Finding elusive control on User Form Don Wiss Excel Programming 2 August 5th 06 02:08 AM
Finding CellRef for Control+Home Jim May Excel Programming 12 May 31st 06 07:04 PM
Tool Tip Text for Form control/ Active-X control Freddie[_2_] Excel Programming 0 October 19th 04 04:14 AM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"