PC Review


Reply
Thread Tools Rate Thread

cell protection based on a formula

 
 
=?Utf-8?B?QUpQZW5kcmFnb24=?=
Guest
Posts: n/a
 
      26th Feb 2006
I would like to ensure cells in a sheet become unprotected once a particular
month has started and protected once a month has ended.

I have a sheet for each calendar month and want the cells to automatically
unprotect themselves when the month starts and then protect themselves once
the month ends. I know I could have a cell showing the current date and I
could easily have a formula to produce a Yes if this date falls within the
month in question.

Is it possible to then apply the cell protection based on this result - or
is there an easier way to do it!

Thanks

Andrew
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to set cell protection by row, based on pre-populated values cm Microsoft Excel Programming 3 12th Nov 2009 12:14 AM
Cell formula protection =?Utf-8?B?Qm9lbmVyZ2U=?= Microsoft Excel Discussion 2 23rd Dec 2005 07:17 PM
Cell Formula reference to cell Based On third Cell Content =?Utf-8?B?R2FicmllbA==?= Microsoft Excel Misc 1 11th Feb 2005 06:36 AM
Cell Formula reference to cell Based On third Cell Content =?Utf-8?B?R2FicmllbA==?= Microsoft Excel Misc 0 11th Feb 2005 05:35 AM
Cell protection after entering formula. =?Utf-8?B?QXNob2sgU2FibmU=?= Microsoft Excel Misc 2 18th Jun 2004 01:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:53 AM.