Okay, this is probably a lot simpler than I'm thinking. Only problem is, I'm new to programming userforms, so I'll need help along the way.

I have 2 worksheets set up, one that's just a blank worksheet with a button on it that pops up my UserForm. The other worksheet has all the current data on it and is hidden and protected.

One of the buttons on the UserForm I want to use to hide the userform, unhide and view the main worksheet, but not make changes except for autofiltering and sorting(sorting is another issue altogether). Then I want to make a macro on cell select that hides that worksheet and brings the UserForm back up.

Is this possible?

PS. On a side note: When I protect the worksheet, it won't let me sort the data even though I have 'Sort' selected as an allowed action. Any way around this?