Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't think there's a hope in hell but I thought I'd ask anyway.
I've added an option to an AutoIndent macro I wrote some time ago that inserts vertical dashed lines at each indentation level in order to assist analysis of code structure. The dashed lines are created by inserting apostrophes on each line at each indentation level. If the code structure is correct, then the parts of each block code statement are aligned at the same indentation degree (as per the AutoIndent macro) and are linked with the dashed lines. This should (yet to be used in practice) be useful for analysis of code with a lot of nesting that is also long. The problem is that the apostrophes make the text in each line turn green (since they are used to create comment block), and therefore, the colouring for key words and statements is lost, hindering analysis. It would be nice if there were a way to just freeze the IDE so that it wouldn't change when I do this. I have another macro that removes the dashed lines (apostrophes) which could then reenable the IDE. Or possibly some other stragegy? Confirmation that there's no realistic hope is also of value since I can then move on. Greg Wilson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help creating a summary tab (strategy) | Excel Discussion (Misc queries) | |||
Strategy Needed | Excel Discussion (Misc queries) | |||
Workbook Switching Strategy | Excel Programming | |||
building invoice - strategy advice | Excel Discussion (Misc queries) | |||
Strategy Query | Excel Programming |