View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default No Cell Selected

Hi,

I have to say this is not a standard request, so here is a non standard
solution.
1. Place an auto shape on a sheet
2. Reduce its size as much as possible.
3. Add code such as the following to the Workbook_Open event

Sheet(1).Activate
ActiveSheet.Shapes("Oval 9").Select

And don't anyone respond with how hokey this is, I know it is. But the
basic idea is you can select anything other than a cell and you aren't
selecting a cell!

--
Thanks,
Shane Devenshire


"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,