Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Highlighting a Range
Hi,
I'm writing a macro that will improve on Excel's graph plotting routine by automating some of the steps. As part of it I would like to have the user select a row by clicking on it. No problem - I can do that: Set activecell_position = Application.InputBox (prompt:="Input desired active cell position", title:="Active Cell Position", Default:=ActiveCell.Address, Type:=8) but what I would like to do is to prevent a range of cells being highlighted accidentally. ok, I know its still the active cell address that's read in - but I want to prevent the highlighting of the range in the first place. Thks....Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STOP Highlighting Multiple Cells | Excel Discussion (Misc queries) | |||
Excel won't stop highlighting (Dec 06) | Excel Discussion (Misc queries) | |||
Excel won't stop highlighting | Excel Discussion (Misc queries) | |||
stop highlighting cells when launched | Excel Discussion (Misc queries) | |||
Cells in Excel will not stop highlighting | Excel Discussion (Misc queries) |