Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need currently selected Excel cell to be highlighted better Peggy Excel Discussion (Misc queries) 4 January 22nd 09 04:43 PM
clicking shortcut opens excel prog, but not highlighted file-why? cavanman Excel Discussion (Misc queries) 1 March 6th 07 11:52 PM
In Excel - Use Windows Explorer instead of File Open to open file KymY Excel Discussion (Misc queries) 1 August 5th 06 09:59 PM
open a non-office file using cell data from excel dcauldwell Excel Discussion (Misc queries) 2 January 16th 06 03:04 PM
can not open excel file, too many different cell formats Abdur Excel Discussion (Misc queries) 1 March 17th 05 12:13 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"