LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default Freeze IDE or other strategy ???

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
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
Help creating a summary tab (strategy) Jeremy Excel Discussion (Misc queries) 1 June 5th 08 06:30 PM
Strategy Needed kleivakat Excel Discussion (Misc queries) 2 March 7th 06 09:09 PM
Workbook Switching Strategy Nigel Excel Programming 6 May 5th 05 06:24 PM
building invoice - strategy advice Excel Discussion (Misc queries) 0 January 3rd 05 01:29 PM
Strategy Query Chuckles123[_73_] Excel Programming 0 November 24th 04 04:22 AM


All times are GMT +1. The time now is 05:33 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"