how to avoid edit of inserted data in Excel?

kotaiah · September 13th, 2006, 06:45 AM

Hi
This is Kotaiah
I am inserting data on Excel sheet but i dont want edit data because of security purpose?

How it is possible.

If i protect sheet , i am uable to insert data. sothat i am expecting answer from ur side asap

Thanks&Regards
Kotaiah.K

Speedle · September 13th, 2006, 07:35 AM

I think thatâs because of properties of cells properties.
Click on trouble cell by right button and chouse the need format.
And there is another way. Click on trouble cell and before text insert â ! (For example if you write â26 it will be just 26)! â means that is âtextâ but not âdataâ.

kotaiah · September 14th, 2006, 12:21 AM

Actually I am using Excel Macros with VBA
in first sheet i have a form and filling data.

This data is going to store in sencond sheet.
i want security for that sheet.

if we protect sheet we are uable to write data.

ASAP

kotaiah · September 14th, 2006, 01:49 AM

Actually I am using Excel Macros with VBA
in first sheet i have a form and filling data.

This data is going to store in sencond sheet.
i want security for that sheet.

if we protect sheet we are uable to write data.

ASAP