Conditional splashscreen in Excel 2000 Macro - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Conditional splashscreen in Excel 2000 Macro

I have created a userform as a splashscreen in a workbook which contains a saveas control to prompt the user to save the masterfile with a specified filename to a location of the users choice. This auto starts when the workbook is opened, however this splashscreen is then also live in the then saved as workbook. How do I specify the splashscreen to only run if the workbook is the masterfile.

Appreciation for any help offered. thanks

Sign In or Register to comment.