Hiding VB Code

skeet4me

New Member
Joined
Dec 11, 2003
Messages
27
IS there a way to hide, or really protect the VB Code in the Visual Basic Editor?
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
If you right-click the project name, and select Properties, Lock project for viewing (you must enter a password), and close the file, you'll need to password to view the code again. I bet somebody has a crack out there for it, though, so take it with a grain of salt. Hope that helps!
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
I bet somebody has a crack out there for it, though, so take it with a grain of salt.
VBA Password Protection is much more robust than Excel. To whit, unless you're a ******* by nature, you'll need a commercial solution, and most users aren't going to shell out the $45+ just to see what you've got.

Smitty
 

joh1135

Board Regular
Joined
Mar 11, 2003
Messages
156
Entered 1 in B7 then tab (Msg box B7) OK
Entered 1 in C7 then tab (Msg box D7) OK
Another message in box (7)
Entered 1 in D7 then tab (Msg box E7) - went down 1 column too late
 

joh1135

Board Regular
Joined
Mar 11, 2003
Messages
156

ADVERTISEMENT

It also continues counting so that if I want to go back and change a value in B7 - I cant

Upon clicking in B7 it jumps to a row in D
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Um, what does this have to do with hiding VBA code?
 

joh1135

Board Regular
Joined
Mar 11, 2003
Messages
156
sorry - wrong post to wrong board

I was wondering where my post went

Sorry
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,173
Members
417,129
Latest member
geekzilla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top