View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Macro to Simulate F2

So what happens if you have a workbook with only this code:

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

And nil else, and no add-ins installed and no personal.xls
running, just nothing else and then close Excel and double-click the file?
It then put A2 in edit mode with me.

RBS


"Lil Pun" wrote in
message ...

No it has never opened VBE, I haven't tried running the macro alone
though either. I just open the file that the macro is actually a part
of.


--
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