Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Conditional unlock for cells

Hi,

I need some assistance in unlocking a range of cells based on date
conditions

For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.

It should not allow the user to enter data for yesterday or
tomorrow.......

Cell should be open only for today's date.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 527
Default Conditional unlock for cells

See your other post


"Selva" wrote:

Hi,

I need some assistance in unlocking a range of cells based on date
conditions

For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.

It should not allow the user to enter data for yesterday or
tomorrow.......

Cell should be open only for today's date.
.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Conditional unlock for cells


This question has nothing to do with phones.

simbu wrote:

I found this site 'Pro Unlocking.com- Unlock Your Phone'
for
unlocking...It provides unlock code and instructions....With the help of
this you can unlock easily...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional unlock johnsail Excel Discussion (Misc queries) 2 March 31st 08 03:04 PM
conditional unlock johnsail Excel Discussion (Misc queries) 3 October 22nd 07 04:24 PM
Unlock cells Siva Excel Discussion (Misc queries) 1 April 26th 07 04:04 PM
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel Excel Worksheet Functions 1 June 24th 05 02:59 PM
Lock and Unlock cells using VBA Peter Excel Discussion (Misc queries) 1 January 29th 05 02:00 PM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"