View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aine_canby@yahoo.com is offline
external usenet poster
 
Posts: 11
Default Unlocked Region within Worksheet

Hello,

I have a worksheet which contains data from a number of files, with
each file given its own column. The user can add files to the
worksheet as they desire. Each column is 100 Cells in height, in terms
of the file data. So, if the user has added 6 files, then there is a
region 6 columns x 100 Rows, where data from the files is presented.

I'd like to lock all the cells on my worksheet except for the 6 X 100
region described above. Of course, this region changes in size as the
user adds files.

How would you suggest I do this,

Thanks for your help,

Aine