Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simulate Check Box | Excel Discussion (Misc queries) | |||
VBA to simulate the enter button? | Excel Programming | |||
Simulate Click Event | Excel Programming | |||
Can I programmatically simulate clicking the 'stop macro' button in the VBE? | Excel Programming | |||
How can I simulate menus through macro (Visual BasiC) ? | Excel Programming |