I'm trying to keep an excel workbook hidden/invisible so that only my UserForms are visible as you work through them.
This code works ok to show my splashscreen with the workbook hidden...
but falls over when opening the first UserForm via the splashscreen command button as highlighted...
Any help will be greatly appreciated as I've spent a couple of hours trying to solve this without success.
Using Excel 2011 for mac