Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselecting a Cell??
Hello Everyone,
I have written a program with a startup page. But, my startup page is for info only and displays information I gathered through an array. Now, the program selects the startup page to view when it boots up. Now, my problem is, IT HIGHLIGHTS cell A1 as though that is where the cursor was last. How do I UNselect so that I see no cells highlighted??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselecting a Cell??
There is an active cell on every worksheet and you can not really get around
that. My favorite way around this is to either hide the active cell behide a logo or shape or to select a cell which is off screen. If you want to you can also set the scroll area so that the end user can not scroll around on the screen once you have hidden the active cell. "Michael Vaughan" wrote: Hello Everyone, I have written a program with a startup page. But, my startup page is for info only and displays information I gathered through an array. Now, the program selects the startup page to view when it boots up. Now, my problem is, IT HIGHLIGHTS cell A1 as though that is where the cursor was last. How do I UNselect so that I see no cells highlighted??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unselecting a Cell??
You can also Protect the Sheet, this way no cell will
appear selected. Gerry -----Original Message----- There is an active cell on every worksheet and you can not really get around that. My favorite way around this is to either hide the active cell behide a logo or shape or to select a cell which is off screen. If you want to you can also set the scroll area so that the end user can not scroll around on the screen once you have hidden the active cell. "Michael Vaughan" wrote: Hello Everyone, I have written a program with a startup page. But, my startup page is for info only and displays information I gathered through an array. Now, the program selects the startup page to view when it boots up. Now, my problem is, IT HIGHLIGHTS cell A1 as though that is where the cursor was last. How do I UNselect so that I see no cells highlighted??? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
How to stop Option Button unselecting one on different worksheet? | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
unselecting not working anymore? | Excel Discussion (Misc queries) | |||
Selecting / UnSelecting sheets | Excel Discussion (Misc queries) |