Turn a range of cells into 'read only'
in [Programming]
|
From: Michael Lanier on 27 Apr 2010 13:56 I want to turn a range of Sheet1 cells into 'read only' when my file is saved. The conditions are as follows: If range A1:A100 (a range of dates) = TODAY() Then range C1:C100 which corresponds to TODAY() is made 'read only' I don't know if it matters, but the sheet will be password protected. Can you help with a macro for this? Thanks. Michael
From: Gord Dibben on 27 Apr 2010 15:17 What do you mean by "read only"? Do you want the cells to be values only? What values are in C1:C100? Do you want the C1:C100 cells to become locked if any corresponding cell in column A matches TODAY? Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 10:56:20 -0700 (PDT), Michael Lanier <michaelrlanier(a)gmail.com> wrote: >I want to turn a range of Sheet1 cells into 'read only' when my file >is saved. The conditions are as follows: > >If range A1:A100 (a range of dates) = TODAY() >Then range C1:C100 which corresponds to TODAY() is made 'read only' > >I don't know if it matters, but the sheet will be password protected. >Can you help with a macro for this? Thanks. > >Michael
From: Michael Lanier on 27 Apr 2010 15:52 Thanks Gord, I'm using a business spreadsheet. When I'm finished for the day, hence the TODAY() entries located in column A, I want all my corresponding entries in column C to become fixed for every transaction entered for TODAY() when I save the file. In truth, there will be other columns other than just C, but they won't be adjacent. I hope this helps. Michael
From: Gord Dibben on 27 Apr 2010 16:13 Still not clear to me. Column A has what? =TODAY() in every cell? Some cells? Column C has what? Formulas? "Fixed" means "values only"? I'm thick and need more detail. Can you post a representative sample of what you have in say A1:A10 and C1:C10 You will need code, I would imagine For each cell in column A that equals Today Convert corresponding cell in column C to value Would that work? Gord On Tue, 27 Apr 2010 12:52:23 -0700 (PDT), Michael Lanier <michaelrlanier(a)gmail.com> wrote: >Thanks Gord, > >I'm using a business spreadsheet. When I'm finished for the day, >hence the TODAY() entries located in column A, I want all my >corresponding entries in column C to become fixed for every >transaction entered for TODAY() when I save the file. In truth, there >will be other columns other than just C, but they won't be adjacent. >I hope this helps. > >Michael
From: Michael Lanier on 27 Apr 2010 17:18
Gord, Picture a check register. Basically, the idea is to enter today's date in column A. My computerized register balances my daily entries and returns a balance for each transaction in column C. When I close the file at the end of the day, I want the amount reflected in C to become permanent so that it cannot be changed at a later date. Therefore, any entry that reflects today's date in A will become permanent (fixed) in C. Sorry about the confusion. I hope this helps. Michael |