Would like to hide specific text inside macro vba code

[keisen]

Working on an Excel document that has several password-protected tabs (i.e. worksheets). These "protected" tabs include working macros with code that effectively unprotects the tab, runs the macro, and then re-protects the tab before exiting.

Here's a sample:
_________________

Please Login or Register  to view this content.

_________________


If possible, I'd like to HIDE the 2 lines of code above that make reference to the password. Is there any way to change a line of code's text color to match the background color, thereby making the line invisible to the reader?

Appreciate any suggestions here.

Thank you.

- Kevon

[Kyle123]

No, but you could lock the project from viewing so to view the code, the user would need to know the password

[Richard Buttrey]

Hi,

As far as I'm aware the VB editor does not give this flexibility. Seems to me that you have two options.

1. Password protect the VB environment so that the macros can't be seen until a password opens them up.
2. Put your password on a sheet which is 'xlVeryHidden', so that it can't be unhidden and made viewable from within the Excel application and pick up the cell containing the password in the macro rather than hard coding it in the script.

However even with the latter, if someone wants to type Print Range("A1") in the Immediate window then they'll discover the password. Option 1 seems preferable.

[keisen]

How do I go about locking the project, Kyle123?

Thanks for the reply back.

[keisen]

How do I accomplish option 1, Richard? Thank you.

_____________________

[Norie]

Select a module, right click and select VBAProject properties where you can add a password on the Protection tab.

[keisen]

Figured out how to lockdown the vba code inside the Excel doc. Any security is better than none when it comes to protecting intellectual property.

Thanks again for the help, Kyle123.

____________________

No, but you could lock the project from viewing so to view the code, the user would need to know the password

[keisen]

Appreciate the help, Norie. Thank you.

_____________________

Select a module, right click and select VBAProject properties where you can add a password on the Protection tab.

[stuzor]

Hi Kevon,

Richard's suggestion for #1 by protecting your VBA module with a password is a good one if your users don't really have much to gain from accessing your VBA. But if the VBA is important enough then people can break into it in just a few minutes. Here is a website that shows you just how easy it is to break the VBA password:
http://datapigtechnologies.com/blog/...-vba-projects/

If the intellectual property is important enough, then I'd recommend one of the tools out there that aim to solve these problems, such as:
Spreadsheet Compiler: www.doneex.com
Spreadsheet Converter: www.spreadsheetconverter.com/
or a product that we built, called HiveLink: https://hivelink.io

Good luck!