Previous Topic Next Topic

Auto_open

Solved/Closed
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010 - Oct 30, 2009 at 08:14 AM
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010 - Nov 2, 2009 at 01:43 PM
Hello
I have a question about Auto_open. Where do I put it in VB Editer? Do I put it in a Module, or Sheet, or Workbook. I have 3 sheets in the workbook. I've tried to put in in each sheet, but it only runs in sheet 2 and sheet 3. If I put it in the workbook, the same thing happins. If I put it in a module, it doesn't run. I've included the macro. I'm using Excel 2007
Private Sub Auto_Open()
Range("A1").Select
ActiveCell.Offset(4, 0).Range("A1").Select
ActiveWindow.FreezePanes = True
Application.Goto Reference:="R600C1"
Selection.End(xlUp).Select
ActiveWindow.SmallScroll Down:=6
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub

I set up each sheet so that the Auto-Open would be the same for each

SelfLearner

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 30, 2009 at 09:45 PM
this reference will be useful to you

http://www.yogeshguptaonline.com/2009/04/macros-in-excel-auto-open-macro-auto.html
0
Answer 2 / 2
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010
Nov 2, 2009 at 01:43 PM
Yep, sure is helpful. Thanks

Mike
0