How to deny deleting content in cells once entered

[saifsawafi]

Hi to all
I'm very new to using VBA with excel. What I seek is very straight forward as below;
1. I would like to write a code that would allow in data entry into the cells, but would deny deleting, and would lock the continent from editing after 10 minutes of entry .
2. How would I make the file to be useable only and only if I enable macros otherwise the file becomes unusable.

[kev_]

deleted by kev

[kev_]

What I seek is very straight forward

no it is not!

I would like to write a code that would allow in data entry into the cells, but would deny deleting, and would lock the continent from editing after 10 minutes of entry .

are you asking for each entry to be timed and then locked after 10 minutes?

[HaroonSid]

Found one more security for my vba project even macro are not enabled.
this will force to enable the macro every time you open workbook if macro is disabled,

thaks to the original coder

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

hope some one find this one helpful

[kev_]

How would I make the file to be useable only and only if I enable macros otherwise the file becomes unusable

One way to achieve this is to save the workbook with only ONE worksheet visible, and that VBA has to be enabled to display the other "important" sheets

Hide with:

Please Login or Register  to view this content.

Can only be made visible again through the use of VBA code:

Please Login or Register  to view this content.

Or you could password protect worksheets and unprotect via VBA