View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default No Cell Selected

On Oct 18, 8:54*am, 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,


If you save while a shape is selected then it reopens with the shape
still selected.
However ActiveCell.Address returns the address of the active cell
prior to selecting the shape.

Ken Johnson