Could someone hopefully point me in the right direction as to what to do. First off my workbook is around 3 mb, so I don't know if I can zip it under guidelines of this forum. It has a main menu (switchboard). The problem I am having is sometimes when I click on a command button to activate another form, I get the message "Microsoft excel has encountered a problem and needs to close", one time I got a run-time error '6' Overflow.
This is the strange thing, usually the main form loads on workbook open. When I go into the vbe and hit run to load the main menu and then click on the command button to load another form, I haven't ever had an error.
Thanks for any suggestions or insights
Josh
Bookmarks