Avatar of dory550
dory550
 asked on

Password-protect my spreadsheet?

Hi Guys
I am really not too much of an expert when it comes to Excel.
Soooooo
This may be a stupid question.

I have designed a unique Excel spreadsheet which is actually an order-form.
I would like to prevent my business competitors from using or copying my code.
I have been checking the internet and discovered that there is no such a thing as an unbreakable password.
My question.
Is it feasible to use a password-protected spreadsheet that once you hack the password it will run a macro that will erase all the existing code.
If this senario is possibly what would be the code I need to run to achieve my purpose?
Thanks
Dory
Microsoft Excel

Avatar of undefined
Last Comment
dory550

8/22/2022 - Mon
jppinto

No, that's is not possible to do. As you said, there aren't "unbreakable" passwords, not on Excel, not some other programs. There is nothing you can do that will allow you to full protect your code from been hacked. Sorry...
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
dory550

ASKER
Teylyn
Thank you for your input
Maybe I did not make myself totally clear .
This order-form is a disposalble piece of software.  It is just a price-list of about 1000 convenience-store items which we email to all our customers weekly.
It has no commercial value!
There is absolutely no legitimate reason to access the code.
Dory
dory550

ASKER
Teylyn
OK
It took a while.
I now understand that cracking a password is actually not an event triggering action
And therefore no module can be deleted unless the user initiates it.
Thanks for your help
Dory
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy