View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Gorham[_3_] Chris Gorham[_3_] is offline
external usenet poster
 
Posts: 31
Default 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