Excel VBA How to hide code for a macro with no needing to ask a password.

rachman3339,
Had there actually been VBA code in the workbook, it could have been hidden with a password to protect it. The code could have been on a module sheet, one of the code panes for the worksheets, or the ThisWorkbook code pane. All of them are protected by the same password. There can also be code behind user forms and chart sheets, but this will be encountered much less frequently.

Breaking the password on a worksheet took less than a minute using free VBA code that is fairly widely posted. The same password was used to protect the workbook. Had this not been the case (or if I needed to break the password protecting VBA code), then commercial software is readily available to break the password. Bottom line: Excel password protection will keep honest people honest, but no more than that.

If you need more security, it is necessary to compile the code into a .dll add-in. I haven't ever done this, but you will need the help of something other than Office Professional to accomplish the task.
Brad

"If You want to have a 100 % secured solution then a good start is to not use any computer."

How true, Dennis :)

Rachman,
Seeing as you are willing to pay for your answers, you always have the option to contract a 'real expert' such as Nigel and Brad, above, to develop a secure application keeping cheats from the answers. It'll cost you a lot more than the privilege of EE membership though, and you will be dealing with the same people in a less informal environment.
Regards,
John T

John  - Thanks for not including me among the "real experts" ;-)

Kind regards,
Dennis

Yeah... and thanks for suggestion that my external freelance consultancy is less formal than my voluntary assistance here.

I resemble that remark!

:)

rachman3339,
I see that you are new to Experts-Exchange. So you may not be aware that the more you participate in a question, the better the results will be.

The reasons for this are two-fold. First, the underlying need behind the question becomes better understood as you participate more. Perhaps you change directions as a result of the discussion, or perhaps additional information is posted that changes the suggestions made. Second, the collaboration process makes it more fun for the participating experts, none of whom receive any compensation for their time other than your appreciation for their efforts. Collaboration generally gives you a better and quicker answer--so everybody benefits.

In this particular question, it is not clear to me whether your aim is to be as clever as the developer of the TV show quiz, or to find a way of hiding VBA code.

Brad

:O
Now I'm embarassed Dennis; I should have mentioned you and  zorvek ,  byundt, matthewspatrick, mvidas,  MalicUK,  roos01,  patrickab, mgh_mgharish, jeverist, ture, brettdj, webtubbs and  ShaneDevenshire but I always thought that two examples were sufficient. :)))))))))))))))

 Nigel, I actually said 'less informal'. However I will cheerfully plagiarize the resemble crack. It would be ironic if your consultancy was less formal but far more expensive. Regardless it has been a pleasure following your answers; you seem to gently guide rather than criticize.
Regards,
John T

Hi John,

Oh yes, less informal, more formal, more reading required next time, me-thinks :)

I don't know about ironic, but a service that was fee-based wouldn't be anywhere near as much fun as my time here.  I may die poor financially, but rich in entertainment.

Many thanks for your comments, though.  Any feedback (good or bad) helps make Experts-Exchange a better place, and obviously praise is well-received :)

Hopefully rachman3339 will come back to us, so we may better understand his/her needs & advise accordingly.

I do like these kind of quizzes, so I hope we can help steer along a route that is advantageous.  It would be a shame to put so much effort into the questions if the end result is never made available for everyone to enjoy.

FYI: Yahoo! host a page, "Yahoo! Attachments", where MS-Excel based quizzes are regularly posted (amongst other items for a slow Friday):

[ http://uk.news.yahoo.com/hot/office-attachments/index.html ]

BFN,

fp.

Hear,hear!!

Good site!!! Cheers!!!
J

Do you need any further assistance,  rachman3339?

Thanks for your feedback in any respect.

BFN,

fp.

in vb6,

add macros dynamically and run, see msdn website knowbase.
then remove all macros when they have finished.

if you tighten up the secrity of the workbook, and include the password in the vb code.
will anyone able to hack it?