Macro: How to avoid cell value editing ?
 

Put a button on the sheet & protect everything else.
mind that protection possibilities depends on excel versions.

Worksheets("x").Protect UserInterfaceOnly:=True

will work on all versions (since xl97?) and
allows your code to work but the user can't do a lot of harm.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Terence" wrote:

Hi,

My macro retrieves data from SQL server and data is placed
on the worksheet. However, I don't want users change /
delete data on the worksheet after data is retrieved from
SQL server. e.g. data is returned to column A of the
worksheet.
Is there anything that I can work on my macro coding so
that users cannot change / delete the data of column A?
Thanks.

Terence

Macro: How to avoid cell value editing ?
 

Thanks a lot!!

-----Original Message-----

Put a button on the sheet & protect everything else.
mind that protection possibilities depends on excel
versions.

Worksheets("x").Protect UserInterfaceOnly:=True

will work on all versions (since xl97?) and
allows your code to work but the user can't do a lot of
harm.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Terence" wrote:

Hi,

My macro retrieves data from SQL server and data is
placed
on the worksheet. However, I don't want users change /
delete data on the worksheet after data is retrieved
from
SQL server. e.g. data is returned to column A of the
worksheet.
Is there anything that I can work on my macro coding so
that users cannot change / delete the data of column A?
Thanks.

Terence


.