Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
G'day there One & All,
I'm just dropping in a quick query at the moment in the hope that someone will know what I'm talking about (a sometimes dubious proposition). I have previously used a utility for the Excel VBE that allowed me to highlight a number of lines, then convert them to Remarks. I could then unconvert them later. Made it quite easy to take out sections of code whilst I experimented. I think I used a right click menu for the operation, but it may have been from the "Tools" menu. I'm not sure. Does this sound familiar to anybody? I simply don't recall its name. I currently have the excellent MZ-Tools, but that's not one of its options. Hoping someone's memory is better than mine. See ya Ken McLennan Qld, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
This is built-in. If you go to ViewToolbarsCustomize in the VBIDE, and on
the Commands tab, select Edit, and there is a Comment Block and Uncomment Block command there that you can drag onto any toolbar. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ken McLennan" wrote in message ... G'day there One & All, I'm just dropping in a quick query at the moment in the hope that someone will know what I'm talking about (a sometimes dubious proposition). I have previously used a utility for the Excel VBE that allowed me to highlight a number of lines, then convert them to Remarks. I could then unconvert them later. Made it quite easy to take out sections of code whilst I experimented. I think I used a right click menu for the operation, but it may have been from the "Tools" menu. I'm not sure. Does this sound familiar to anybody? I simply don't recall its name. I currently have the excellent MZ-Tools, but that's not one of its options. Hoping someone's memory is better than mine. See ya Ken McLennan Qld, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
.... or just make the Edit toolbar visible
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ken McLennan" wrote in message ... G'day there One & All, I'm just dropping in a quick query at the moment in the hope that someone will know what I'm talking about (a sometimes dubious proposition). I have previously used a utility for the Excel VBE that allowed me to highlight a number of lines, then convert them to Remarks. I could then unconvert them later. Made it quite easy to take out sections of code whilst I experimented. I think I used a right click menu for the operation, but it may have been from the "Tools" menu. I'm not sure. Does this sound familiar to anybody? I simply don't recall its name. I currently have the excellent MZ-Tools, but that's not one of its options. Hoping someone's memory is better than mine. See ya Ken McLennan Qld, Australia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
I didn't remember myself immediately, I just recalled having used it myself.
When it wasn't in MZ-Tools, I thought that it must be a built-in. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ken McLennan" wrote in message ... G'day there Bob, In article , says... ... or just make the Edit toolbar visible Thanks very much for that information. That was exactly what I was looking for. I dunno why, but I had it in my mind that it was an Add-In or some other utility and never bothered looking at the editor itself. Now that you've pointed it out to me and I have it in front of my face I recall having the toolbar visible previously and that this is where I accessed it from. How come these things can never be remembered until AFTER someone reminds you? Thanks once again. -- See ya, Ken McLennan Qld, Australia |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a Utility with Multi Line REM conversion
G'day there Bob,
I didn't remember myself immediately, I just recalled having used it myself. When it wasn't in MZ-Tools, I thought that it must be a built-in. Well it's a good thing that one of us thought!! Otherwise I'd still be sitting here clicking keys for each line =) Thanks again -- See ya, Ken McLennan Qld, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi line cell | Excel Discussion (Misc queries) | |||
Multi Line text box | Excel Discussion (Misc queries) | |||
Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions |