Conditional Locking Of A cell

R

Rick

Is there a method either within excel or or via a VBA macro to
conditional lock cells in a excel spreadsheet

The proble we are having is that we have a template spreadsheet and
people are accidentally changing historical data. We would like to
lock the spread sheet so that everytime it opens certain historical
cells automatically lock based on the system date

Got it?
 
N

Nick Hodge

Rick

This could be done but it would need workbook_open event code. This could
lock cells and protect the sheet they are on, based on virtually any
criteria.

The issues are

How many criteria you have an where these will be stored, on a hidden
'control' worksheet or hard coded in the code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
R

Rick

Not sure what your question is
I have Biweekly sections that I would like to lock immediately after
the date the section comes is entered (I.e the June 15th sections
"Locks" on June 16th

Assume the cellrange for the june 15 t section is (A282:I292)
although if it would help I could name the section
 
Top