Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selected Cell
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I only make a cell available if an option from a differentvalidated cell is selected in Excel? | Excel Worksheet Functions | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel |