View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default No Cell Selected

Excel will always have a cell selected somewhere.

Which one is up to you and could be coded to open with a particular sheet
and cell selected.


Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 14:54:04 -0700, Brent E
wrote:

Currently, if I open a spreadsheet, the file defaults to the last cell or
range selected prior to the last save. Is there a VBA command that deselects
any cell so when a file is opened, no cell is selected until the user clicks
on something?

Thanks,