I was wondering if there was any way to hide which cell you have selected within excel (for presentation purposes). I want the cursor itself (to navigate), but I want the box that highlights which cell i am clicking on invisible if possible.
Thanks!
Asked
Active
Viewed 4,148 times
2
-
No there is not – Tom May 24 '17 at 14:16
-
A solution would be (using Excel-vba) to have an image hovering on top of the Excel Sheet. It looks quite complicate to operate. Why do you need the selected cell to be actually selected? – J. Chomel May 24 '17 at 14:19
-
Well, I don't highlight any cell. At the moment, I have a worksheet that's supposed to look like a webpage control panel with buttons on it. However, each time i click on a button, the cell highlights itself with a box - giving away the fact that i am actually using excel. – Rachael May 24 '17 at 14:27
-
To "hide" the selection box if you *don't* need to otherwise navigate/scroll around the worksheet (and to "lock" the visible top-left set of cells in place) you could use something like `Range("A1").Select: ActiveSheet.ScrollArea = ActiveWindow.VisibleRange.Address: Cells(500, 500).Select`. It prevents scrolling with [`ScrollArea`](https://docs.microsoft.com/office/vba/api/excel.worksheet.scrollarea) and selects a cell far outside of the allowable scroll area (which is the [`visibleRange`](https://docs.microsoft.com/office/vba/api/excel.window.visiblerange)). – ashleedawg Feb 03 '22 at 13:18
2 Answers
0
If you're using a button object on your worksheet, it shouldn't highlight any cell. If you're using a cell as a "button", your best bet would be to hide and not use column A on your worksheet and then create a module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Select
End Sub
which will select the now hidden cell A1, and hopefully no one notices...
Dave
- 51
- 8
