Hello All,
I have a problem, I've worked up some code that solves a pretty sought after equation in my field of work, so now we want to try and protect the file so that no one can a: take our logo off of the spreadsheet, and b: make sure no one can get the vba code out of the worksheet. Is there any way to do this in excel 2007?
Thanks for any help,
Scott H.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Note that Excel does not provide extreme security. If someone really wants to they will get at the code.. there are many hacks available online...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Can Scott change all of the font color in the VB Editor window to white?
If so, the code stealers would not readily see the code written there unless they just happened to swipe over it with their mouse. I'm not aware of a way to do this...thus the question.
EDIT: to change colors(fonts/background) in VBA editor is under Tools/Options
Last edited by jwright650; 01-03-2011 at 02:35 PM. Reason: added comment
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
First off, thanks all of you for help, but i'm having an issue still. I have successfully protected the VBA code, but when i combine that with protecting the workbook, the workbook won't let me run the code because it's protected so it doesn't trust it...any thoughts?
Perhaps this will help:
http://www.cpearson.com/excel/CreateAddIn.aspx
or http://www.fontstuff.com/vba/vbatut03.htm at the bottom. Password protect your code.
nevermind what I suggested Scott....it only works on the computer that you changed the font color on...LOL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks