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
|