Thread: lock cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] n_kleyn@hotmail.com is offline
external usenet poster
 
Posts: 2
Default lock cells

Hi,
I have an information in cells D1:J10.
This information will be updated and added . It means that number of
row can be change any time.
When program is running I use command:
Worksheets("sheet1").Columns.Clear
To save this info I tried to lock that column before Clear:
Worksheets("sheet1").Range("D1:J10").Locked = True , but it is
doesn't help.
How can I save info in that columns.
Thanks'