Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Code to hide dark black selector box?
Is there any VBA Code to hide the dark box that indicates the currently
selected cell? My sheet I have has no need for this to be seen. Hiding it would be nice. TIA! Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Code to hide dark black selector box?
If you protect the sheet in code, you can make it so the user cannot even select
a cell. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect Password:="hi" .EnableSelection = xlNoSelection End With End Sub Or maybe you could just select a cell that's way off the screen (IV65536?). Scott B wrote: Is there any VBA Code to hide the dark box that indicates the currently selected cell? My sheet I have has no need for this to be seen. Hiding it would be nice. TIA! Scott -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Seiko Dress Two-Tone Dark Grey Steel Black Mens Watch SKP310 | Excel Worksheet Functions | |||
How to hide VB code from Excel file | Setting up and Configuration of Excel | |||
why are some gridlines in an excel worksheet dark and some light? | New Users to Excel | |||
what is the best way to hide code in excel? | Excel Programming |