open excel file with cell highlighted

  • Thread starter Thread starter rakka rage
  • Start date Start date
R

rakka rage

is there a way to open a excel file with a specific cell
highlighted?

like, perhaps, a commandline parameter?

i know you can copy & paste shortcut onto the destop to a
cell and it creates a strange "shortcut into document"
file... is there a way to do this programatically?

please & thanks.
 
Use an auto_open event in a regular module or the workbook_open event in the
ThisWorkbook module.
sub auto_open()
sheets("sheet1").select
range("a6").select
end sub
 
Back
Top