Selected Cell

[Always Learning]

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.

 

[Jim Rech]

You could change the sheet's EnableSelection property to NoSelection and
then protect the sheet. Then no cell is selectable and the cell selector is
not visible.

--
Jim Rech
Excel MVP
| 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.
|
|

 

[George Nicholson]

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.