View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default No Cell Selected

Hi Brent

I don't think you can have a situation with no cell selected, but the
following code would put the cursor in cell A1 of Sheet1
Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").Select
Range("A1").Activate
End Sub

Copy above code
Alt+F11 to invoke VB Editor
Control+F1 to open Project Explorer
Double click on ThisWorkbook
Paste code into white pane
Alt+F11 to return to Excel.

Save the workbook.
When it is opened next time cursor will be on sheet1 cell A1.
Change to suit

--
Regards
Roger Govier

"Brent E" wrote in message
...
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,