ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Locking majority of cells on a Worksheet (https://www.excelbanter.com/excel-programming/394254-locking-majority-cells-worksheet.html)

[email protected]

Locking majority of cells on a Worksheet
 
Hey,

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 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



All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com