Kill excel if Macro password is wrong

**mani.ragi** · 03-27-2010, 07:38 AM

Hi all,

I need a help. I had password protected the VBA Code but still i want to secure it by putting minimum attempts to login if the attempt fails the code has to kill the VBA code or excel worksheet.

can I have copy or sample code or work sheet on this.

@ moderators: I don't know ,either it's a repost or something frankly this is my first post ... i haven't found any thread related to this topic.....please excuse if it's repost and provide me the link.....

Thanks,

Mani

**Domski** · 03-27-2010, 07:46 AM

To my knowledge this is not possible I'm afraid.

You could maybe look at distributing your code as a COM add-in: http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Otherwise you'll just have to live with the fact that people will be able to get to your code if they really want to.

Dom

**mani.ragi** · 04-06-2010, 07:49 AM

more help please.........

**dominicb** · 04-06-2010, 09:52 AM

Originally Posted by Domski

To my knowledge this is not possible I'm afraid.

You could maybe look at distributing your code as a COM add-in: http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Otherwise you'll just have to live with the fact that people will be able to get to your code if they really want to.

Dom

Good afternoon mani.ragi

Domski has pretty much hit the nail on the head - and he's perfectly correct.
Excel is not a secure development medium ; it's something professional developers have to live with, like it or not.

DominicB