what is the "formload" script for excel

Good afternoon stin25

Originally Posted by stin25

I dont have any programming experience with excel. I do however with VB but cant figure out what the "formload" script is for excel. Im needing my workbook to open to a certain page when the file is open but it sometimes doesnt.

Excel will always open at the page it was last saved on. You can switch to this page on opening by using a macro like this in your ThisWorkbook module :

Please Login or Register  to view this content.

The Workbook_Open routine will fire when the file is opened.

Remember, that if you get stuck with syntax with VBA (unlike VB.Net) you can just record a macro and work with that (Tools > Macro > Record New Macro).

HTH

DominicB