Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
If I have more than one Sub in the same module then the VBE draws that horizontal lines separating the 2 subs from each other. Many times I place comments before the start and at the end of the sub depending on my whims. Now, I have problems with the horizontal line when it doesnt know whether a comment belongs to the sub above or the sub below. How do I control this line? Please note, this is the same line inserted by VB just after option explicit whenever we insert a new procedure. Thanks a lot, Hari India |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't think you can. You can avoid this by placing all comments related to
a sub within that sub. -- Vasant "Hari Prasadh" wrote in message ... Hi, If I have more than one Sub in the same module then the VBE draws that horizontal lines separating the 2 subs from each other. Many times I place comments before the start and at the end of the sub depending on my whims. Now, I have problems with the horizontal line when it doesnt know whether a comment belongs to the sub above or the sub below. How do I control this line? Please note, this is the same line inserted by VB just after option explicit whenever we insert a new procedure. Thanks a lot, Hari India |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Vasant
Thnx for your reply. Thanks a lot, Hari India "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... I don't think you can. You can avoid this by placing all comments related to a sub within that sub. -- Vasant |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hari,
You can remove the lines in Tools | Options | Editor(tab) . Uncheck "Procedure Separator". Then make your own with '------- Regards, Jim Cone San Francisco, USA "Hari Prasadh" wrote in message ... Hi, If I have more than one Sub in the same module then the VBE draws that horizontal lines separating the 2 subs from each other. Many times I place comments before the start and at the end of the sub depending on my whims. Now, I have problems with the horizontal line when it doesnt know whether a comment belongs to the sub above or the sub below. How do I control this line? Please note, this is the same line inserted by VB just after option explicit whenever we insert a new procedure. Thanks a lot, Hari India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mystery Black line appearing around a group of fields | Excel Discussion (Misc queries) | |||
Horizontal Line | Excel Discussion (Misc queries) | |||
Remove Black line above Data which include formulas | Excel Discussion (Misc queries) | |||
Screen Goes Black when Draw Line | Excel Discussion (Misc queries) | |||
Horizontal line on line chart | Excel Programming |