Unselecting a Cell??

  • Thread starter Thread starter Michael Vaughan
  • Start date Start date
M

Michael Vaughan

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???
 
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.
 
You can also Protect the Sheet, this way no cell will
appear selected.

Gerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UnSelect the copied to range after copy... 4
Unselect Cells 6
Unselect a Cell?????? 4
Excel Typed text appears in wrong cell 0
EnableEvents = False not working ??? 4
Activecell select properties 5
unselect cells 2
"NxtRow = Cells(Rows.Count," giving me fits 3

Back
Top