Thread: Selected Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Selected Cell

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
"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.
|
|