Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date With VBA
Hi folks,
I am trying to set up something so that if the value in column B is Saturday or Sunday it formats the row between column A to Column O gray and locked. Very new to VBA :-) Thanks, Danny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date With VBA
place this in worksheet module
sub worksheet_change(byval target as excel.range) if target.column < 2 then exit sub if target = "Sunday" or target = "Saturday" then with range("a"&trim(str(target.row))+":o"&trim(str(targ et.row))) interior.colorindex = 15 ..locked = true end with end if end sub this will trigger everytime you type something in column 'b' -- When you lose your mind, you free your life. "Danny Jurmann" wrote: Hi folks, I am trying to set up something so that if the value in column B is Saturday or Sunday it formats the row between column A to Column O gray and locked. Very new to VBA :-) Thanks, Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |