"hidden" text on VBA modules?
"hidden" text on VBA modules?
(OP)
Is it possible to "hide" the text on a VBA module in Excel?
Reason I ask is I was given a very complex (publicly distributed) workbook about "Topic A". There are a number of modules, mostly of very simple code and about half or more of which have no text at all. I tried Ctrl + End to go to the end of the document, works on 'full' modules but gets nowhere on the empty modules.
I'm thinking this is just lack of housekeeping to retain empty modules. Or is there some secret to hidden text that I don't know about?
The level of good housekeeping sometimes influences my overall confidence level. : - )
Reason I ask is I was given a very complex (publicly distributed) workbook about "Topic A". There are a number of modules, mostly of very simple code and about half or more of which have no text at all. I tried Ctrl + End to go to the end of the document, works on 'full' modules but gets nowhere on the empty modules.
I'm thinking this is just lack of housekeeping to retain empty modules. Or is there some secret to hidden text that I don't know about?
The level of good housekeeping sometimes influences my overall confidence level. : - )





RE: "hidden" text on VBA modules?
Simple TEXT will not compile, using the Debug > Compile VBAProject.
The only other TEXT to search for is '
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: "hidden" text on VBA modules?
VBA editor appears to have no options at all with regard to fonts.
The End of nothing is nothing.
RE: "hidden" text on VBA modules?
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: "hidden" text on VBA modules?
If you are recording macros, this is what usually happens.
It is a good practice to add/delete, name and organize modules appropriately to contain procedures of some commonality. Often you'll just need only one module containing all your procedures.
Some module names that I might have are: DataAcquisition, ChartProcs, Utilities, DataAnalysis, BOM_DrillDown.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: "hidden" text on VBA modules?
Simple TEXT will not compile, using the Debug > Compile VBAProject."
I really didn't care what was on/in the seemingly empty modules. comments. user defined worksheet functions. VBA subroutines. VBA functions. I didn't care, I just wanted to know if there was "something" there. Thanks for the help.
RE: "hidden" text on VBA modules?
If there's a compile error, there's sumpin!
If there's 'comment, there's sumpin!
Otherwise ain't nutin!
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: "hidden" text on VBA modules?
like I said. "housekeeping"
RE: "hidden" text on VBA modules?
RE: "hidden" text on VBA modules?
If there's executable code, there will be an end something.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: "hidden" text on VBA modules?
Then storage got cheap and code size exploded, so paging through a hex dump can take considerable time. ... not to mention that the file format can make it difficult to see what's going on.
To sort of answer the OP question in a disappointing way, the complexity and size of today's binaries makes it possible to hide just about anything in a file, in a way in which the intended file reader will not detect it, or not say anything about it.
Trivial example: in the ancient MS Cardfile format, it's possible to insert a few bytes between the end of a given card and the beginning of the next card. The Cardfile app will not display or complain about the presence of that extra data.
Worse, malicious code can also be inserted and go undetected.
Nontrivial example, even more ancient: Tom Almy issued a programming challenge. I forgot whether it was in CP/M or MSDOS, but it was a small program that displayed 'Hello World' and exited normally. The challenge was to change the displayed text to anything else. The text 'Hello World' did exist in the binary, but the displayed text did not come from that string, so changing it made no difference in the program's behavior. Over the course of several weeks, I traced it through two levels of obfuscation before giving up. ... and I don't give up easily.
You are wise to be suspicious of binaries that have 'empty' parts.
Mike Halloran
Pembroke Pines, FL, USA
RE: "hidden" text on VBA modules?
RE: "hidden" text on VBA modules?
Dik
RE: "hidden" text on VBA modules?
In any case, it's apparent to me that the creator of the spreadsheet has a lot of leftover items and inefficiencies in the workbook. Simply inserting the application commands to temporarily turn off screen updating and automatic calculation sped up routines by some incredible percentage (as from 'watching paint dry' to 'lickety split'). They were ecstatic to learn of these commands. I don't have the heart to be too critical of the project.
RE: "hidden" text on VBA modules?
Dik