Conditional Locking Of A cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick@aol.com - 18 Dec 2006 19:01 GMT

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?

Reply to this Message

Nick Hodge - 18 Dec 2006 19:48 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Is there a method either within excel or or via a VBA macro to
> conditional lock cells in a excel spreadsheet
[quoted text clipped - 5 lines]
>
> Got it?

Reply to this Message

Rick @aol.com - 26 Dec 2006 19:12 GMT

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

>Rick
>
[quoted text clipped - 6 lines]
>How many criteria you have an where these will be stored, on a hidden
>'control' worksheet or hard coded in the code

Reply to this Message

Rate this thread: