ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   open excel file with cell highlighted (https://www.excelbanter.com/excel-programming/278855-open-excel-file-cell-highlighted.html)

rakka rage

open excel file with cell highlighted
 
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.

Don Guillett[_4_]

open excel file with cell highlighted
 
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

"rakka rage" wrote in message
...
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.





All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com