Re: VBA - what has been cliked?
Thanks for thinking on this some more. This is the button that I'm using and refer to above (apologies if I wasn't clear). This gives me my desired behaviour in that it just closes the active workbook but leaves Excel open, with the Personal workbook still hidden. The only issue is that users can still click the normal close button.
Not to worry - I guess I'll need to make it up to the user...