Front End Sheet

  • Thread starter Thread starter Rentapen
  • Start date Start date
R

Rentapen

Private Sub Workbook_Open()
Call MyMacro
End Sub
Click to expand...
Where "MyMacro" is the name of YOUR macro.
Click to expand...

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