Perhaps the easiest solution is to add some code in the form's Initialize event to reset the default views on the worksheet.

You could also get that code to read the status of the worksheet to 'prefill' the userform settings to match the current status of the worksheet. This would avoid the need to reset everything when you only want to make a single change. It would probably require an extra button to clear an option though since it is not immediately apparent how to clear ALL options once one has been selected.

If you want to control the visual label positions WHILE the userform is showing then you need to add code to run as checkboxes and Option buttons are manipulated. At the moment all the magic happens AFTER you click the "Create inner..." button but you can move that out to all of the option/checkbox "on change" events if you want to micromanage it.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Andrew,

I understand the concept of what you're saying but I have no concept on how to even begin the coding for it... definitely way way above my level of understanding of VBA.

Thanks heaps for all the assistance you have provided me - it is absolutely appreciated. Just wish that I was able to catch up with you and shout you a couple of beers in appreciation!

cheers
Mike