Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am trying to fill up values in a worksheet with hundreds of columns and rows. For every new session of data entry a macro is automatically run protecting the worksheet leaving only one column unprotected, the one in which data will be entered. Column B holds the description of all items. Is it possible to highlight the corresponding cell in column B while the target cell changes position in the unprotected column? This will help to make data entry much easier and avoid mistakes in entering values to the wrong row. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
coloring cells | New Users to Excel | |||
coloring cells | Excel Discussion (Misc queries) | |||
COLORING IN CELLS | Excel Discussion (Misc queries) | |||
Coloring certain cells | Excel Worksheet Functions | |||
Coloring cells thru VBA | Excel Programming |