Apparently you used Chip Pearson's TimeBomb code.

Did you read Chip's comments on Excel security?

Only effective to keep "honest" persons from hacking your workbook and its
code.

Read this from Chip's site.........................

All protection mechanisms in Excel are really intended to prevent the user
from accidentally changing a value or some code. The security just isn't
strong enough to provide real protection of proprietary information or
information or code with intellectual property value. For that level of
security, you should be writing your code in Visual Basic 6 or VB.NET. See
Creating A COM Add-In for details about creating a COM Add-In and Automation
Add Ins A Function Libraries for details about creating an Automation
Add-Ins.

Another point.........................

You cannot change a user's macro security settings via code.

If you could, there would be no point in having levels of macro security.


Gord Dibben MS Excel MVP

On Fri, 13 Mar 2009 20:26:01 -0700, Som
wrote:

dear all,

thanks for your involvement .

now the file is deleting if macro runs ....

1. how protect / encrypt the code.

2. next concern is Macro security is by default HIGH , I cann't give up !!!!
pls help me find out the way..... is there any option that wherever the file
will be openned the Macro security will be changed to LOW ??

3. is there anyother way apart from Macro to do the same?

I need to complete the job

waiting.......

"David J. Braden" wrote:

Look under the Tools menu when you are in VBA, not under Excel's tools.
Dave

Som wrote:
unable to find the same, can u please describe more how to go?

"Jacob Skaria" wrote:

Hi Som

On your query on how to protect macro
User Tools--VBA Properties--Protection to protect the macro

If macro security is by default set to high; then there is no point trying
out with macros.

If this post helps click Yes
-------------
Jacob Skaria


--
Please keep response(s) solely within this thread.