LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro to Simulate F2


I have a macro setup so when that the file is opened the cell A2 will be
in edit mode (the cursor or blinking line will be in cell A2) Here is
the macro:

Private Sub Workbook_Open()
Range("A2").Select
avoidloop = True
Application.SendKeys "{F2}"
End Sub

The problem is it only works when I open the file after opening Excel,
you know click on File - click Open - click Filename.xls then Open
and not when I directly open the file by double clicking it. Is there
anyway to fix it so that it opens that way anyway the file is opened?


--
Lil Pun
------------------------------------------------------------------------
Lil Pun's Profile: http://www.excelforum.com/member.php...o&userid=33840
View this thread: http://www.excelforum.com/showthread...hreadid=536159

 
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
Simulate Check Box Karen Excel Discussion (Misc queries) 15 April 27th 09 06:34 PM
VBA to simulate the enter button? Bob O[_2_] Excel Programming 3 August 15th 05 05:16 PM
Simulate Click Event ben Excel Programming 5 June 9th 05 09:45 PM
Can I programmatically simulate clicking the 'stop macro' button in the VBE? Alan Excel Programming 9 January 24th 05 01:15 AM
How can I simulate menus through macro (Visual BasiC) ? byv770 Excel Programming 0 November 17th 04 10:53 PM


All times are GMT +1. The time now is 07:10 AM.

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

About Us

"It's about Microsoft Excel"