Thread: Selected Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
George Nicholson[_2_] George Nicholson[_2_] is offline
external usenet poster
 
Posts: 170
Default Selected Cell

1) Make sure one of your buttons is larger than the cell beneath it, then
select that cell (using the arrow keys, the Name box, code, etc.)
or
2) Even if you have restricted the user from scrolling beyond a certain area
using ScrollArea or whatever, you can still select an "offscreen" cell
(using the name box or code) and the screen will stay put. Once selected
this way, arrow keys won't change the ActiveCell.

(The Name Box is the control to the right of the Formula Bar in Excel's user
interface. If you type or select an address or range name it acts as
"go-to".)
HTH,
George Nicholson

Remove 'Junk' from return address.


"Always Learning" <NoMoreSpam@MyEmail wrote in message
...
Hi Guys,

Can anyone tell me how I turn off the border that highlights the selected
cell.
My worksheet contains 3 option buttons and a command button but the
highlighted selected cell looks bad.

I used to just scroll down the sheet until I was one page down, select a
cell and leave it there and then page up.
Now I restrict the user from scrolling beyond the buttons so that they are
always visible which stops me from doing that now.

Any help would be appreciated.

Best Regards,

Steve Wilson.