Here's some information that Jan Karel Pierterse (
http://www.jkp-ads.com)
provided about how to really lock-down/protect your VBA code:
http://www.microsoft.com/office/comm...337&sloc=en-us
I'll save you a trip to the link, but wanted to give credit where it was
due, by posting the meat of it he
1. Save the Excel workbook (.xls) file into an add-in (File SaveAs.....)
2. After you have the saved add-in (.xla), close the Excel workbook (.xls)
3. Double click on the add-in to open it
4. Press Alt+F11 to access the add-in's vba project
5. Lock the vba-project with a password
6. Double-click on the "ThisWorkbook" code module
7. Press F4 to open the Properties window
8. Change the "IsAddin" status to FALSE
9. Return to Excel by Pressing Alt+Q (or close the vbe window)
10. Go to Tools Share Workbook
11. When the dialogue appears, check the box for: (Allow changes by.....)
12. Press OK to close the Dialogue
13. When prompted to save, Press OK
14. Press Ok to accept that "macros cannot be accessed"
15. You should feel giddy at this point because you just realized what you
have
been missing right under your nose
16. Verify that the [SHARED] appears in the application title bar
17. Now save the workbook again as an Add-in (File SaveAs...) overwriting
the
previous one
18. Close this Excel workbook without saving the changes (you don't need it)
19. Test out your newly saved add-in (open it, access the vbe, try to expand
the project window, you should get the new message "Project is Unviewable"
20. You're done
"Luke M" wrote:
And I learn a little bit more!
Thanks for the correction JP.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"JP" wrote:
A simple search for "vba password hack" will have you rethinking the
idea that VBA password protection is safe for protecting intellectual
property.
--JP
On Feb 9, 11:56 am, Luke M wrote:
First, some links to several "Excel Experts"www.chandoo.orgwww.peltiertech.comwww.cont extures.comwww.spreadsheetpage.com
Each has their own specialties, so that may determine what model you want to
follow. In basics, you need to get your name out there and become established
as someone that people can trust and know about.
These days, the goto method usually involves starting a blog where you
discuss XL topics, maybe offer a few free XL workbooks showing off some of
your stuff. Once traffic starts to build, you could get some advertisements
going on your site to generate revenue. Work at getting more people to notice
your site, and start offering your services (for $$$). All the experts I
listed are very approachable, and you could probably write to them for
further advice/detail. Chandoo's site is relatively new, so he would probably
have a lot of insight as to becoming recognized as an expert.
I'd hang onto the VBA knowledge. There's still a large amount of people
using it, and it provides so much more power to XL. Also, its one of the few
parts of XL that can be password protected for security, thus preserving your
intellectual property, if so desired.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
.