Disable Developer tab of Excel 2007 using Programming

**anp24** · 02-11-2011, 06:13 AM

Hello,
How do I disable Developer tab of Excel 2007 using Excel Programming, so that after creating macros in the excel sheet. They cannot be tampered or cracked by other person

Thank You
Regards
Anoop

**Domski** · 02-11-2011, 06:24 AM

Can you not just lock your VBA project with a password?

Dom

**anp24** · 02-11-2011, 06:26 AM

Hello,
the password can be cracked

**Domski** · 02-11-2011, 06:30 AM

True but pretty much whatever you do it will be possible to get round it.

You'll just have to live with the fact that if people really want to get at your code they will do.

Dom

**anp24** · 02-11-2011, 06:43 AM

Hello,
But there must be some way for doing this
Thanks
Regards
Anoop

**royUK** · 02-11-2011, 06:49 AM

If I opened your project & it messed my Excel settings up I would not be amused. Basically, if you need to ask how, then you don't know how to fix problems you may cause as well. Basically, don't even consider it.

If you have such code then it will only run if macros are enabled, you can't force a user to do that.

If you manage to hide the Developer Tab it won't stop anyone with the knowledge or software removing the VBA password in seconds

**Domski** · 02-11-2011, 06:51 AM

I don't understand why you think doing this will be any better than password protecting the vba project. If anything it would be easier to get round.

Dom