INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

"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. : - )

RE: "hidden" text on VBA modules?

If you're looking for PROCEDURES in a module, why not the Procedure drop down on the upper-right?

Simple TEXT will not compile, using the Debug > Compile VBAProject.

The only other TEXT to search for is '

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: "hidden" text on VBA modules?

I don't think so.

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?

I've seen workbooks with scores of modules, often with one procedure per module.

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: "hidden" text on VBA modules?

(OP)
"If you're looking for PROCEDURES in a module, why not the Procedure drop down on the upper-right?

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 are Procedures, there's sumpin!

If there's a compile error, there's sumpin!

If there's 'comment, there's sumpin!

Otherwise ain't nutin!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: "hidden" text on VBA modules?

(OP)
so, there was no "there" there.

like I said. "housekeeping"

RE: "hidden" text on VBA modules?

It is not necessary to have the code in a module: you can also have code in the spreadsheets

RE: "hidden" text on VBA modules?

Search for the word end in the entire project.

If there's executable code, there will be an end something.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: "hidden" text on VBA modules?

It used to be a simple matter to page through any binary using a 'hex editor' if you wished to change it, or Vern Buerg's 'list' if you didn't, just to see what was there.

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?

When in doubt, delete the modules and save the spreadsheet under a new name. If the spreadsheet still works, you'll know the modules didn't do anything. Note: If all of the modules are blank, odds are the spreadsheet does not contain any macros. By default, every time you "Record a New Macro" it creates a module for the new macro. And the module remains even if the macro is deleted, unless you delete the module in the VB editor.

RE: "hidden" text on VBA modules?

Check that the font and background colour are not the same. Sort of makes text 'disappear'.

Dik

RE: "hidden" text on VBA modules?

(OP)
dik, that was on my mind too (text color same as background) but that doesn't seem possible in Excel 2007, that I can see. But I am not positive.

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?

I use openoffice at home... and, I can format the fonts.

Dik

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close