Cursor Placement

[WLMPilot]

I need to have the cursor placed in cell B2 upon opening a particular
workbook with the active sheet being "Order". Can someone please tell me how
to do this?

Thanks,
Les

 

[Dave Peterson]

Put this in a general module:

Option Explicit
Sub Autpen()
application.goto thisworkbook.worksheets("order").range("b2"), scroll:=true
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm