Front End Sheet

[Rentapen]

Private Sub Workbook_Open()

Call MyMacro
End Sub

Where "MyMacro" is the name of YOUR macro.

I gleaned this from mrexcel but can not seem to put into action. In my
workbook I would like a very special "FRONT PAGE" data sheet (out of 10) to
start no matter what the last sheet shown was at shut down. I can neither
get the VBA "worksheet_open ( )" or the the macro line to work. Direction?

regards
just wandering
rentapen

 

[Rentapen]

Thanks John, I found my trouble was greed. I am trying to run a splash
screen and front end sheet on loading. I just can't seem to put the 10
pounds into a 5 pound bag. I don't know vba enough to try and piggy back a
userform.show onto a worksheet.activate or vice versa, and I can't seam to
double a Workbook_Open( ) command.
Regards
rent

 

[Rentapen]

I thought for sure I tried it that way, well maybe not exactly that way,
well.
Thanks guy, yeah it worked just as planned, two million atta-boys.

regards
rent a pen