User Form to select Custom View

I'm new to setting up User Forms in Excel. I would like to be able to have the Workbook open, and a User Form pop up, and have the option of picking the Custom View for the Workbook. There would be 3 options, a Full view (with password), a Summary (which would be standard view), and another Custom View (for another Activity, that would have password as well). And of course, when the workbook gets closed, it would go back to Standard View.

I have a macro right now, when ran, asks for a password, and unhides 2 sheets. When the workbook is closed, it hides those sheets again. So, I just need to expand a little more on this.

I need a little help getting started on it, as I'm still getting my feet wet when it comes to Visual Basic in Excel.

I would appreciate any help in the right direction.

Hello sburgess,

Welcome to the Forum!

It would be easier and faster to help you modify your code if can post the workbook.