open excel file with cell highlighted

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.
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top