Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need currently selected Excel cell to be highlighted better | Excel Discussion (Misc queries) | |||
clicking shortcut opens excel prog, but not highlighted file-why? | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
open a non-office file using cell data from excel | Excel Discussion (Misc queries) | |||
can not open excel file, too many different cell formats | Excel Discussion (Misc queries) |