How to make a start up/ welcome screen?

thanks for all your help guys! -Prizeless!!

Now, I really want to make some sort of a welcome/startup box/screen to inform the user on how my sheets are set up.

Any good ideas?


Sincerley yours, Andreas.

Hi,

you can use the Workbook_Open event to force something to happen whenever the workbook is opened.

Hit Alt-F11 to open the VBA Editor, then double click on ThisWorkbook and enter your code in the code window. You could either do a message box as per code below, or go to a specific tab in the worksheet that has your info. The latter might be easier to maintain.

code for showing a message box:

Please Login or Register  to view this content.

code for navigating to Sheet1

Please Login or Register  to view this content.

Hope this helps