I'm learning VBA from books and the internet. Forgive me if this is really dumb question.
I'm developing a VBA application consisting of numerous Userforms, and my data exists on several worksheets within the same workbook. In some cases, I want to navigate from a userform to a protected worksheet where the user can double-click to select some codes from a complex table. The user can return to the Userform by double-clicking a specfic cell and the selected codes from the worksheet are then processed in Userform procedures. Most of this works fine.
My problem: I can't find a way to actually show the worksheet. In testing, I've hit Alt F11 to get to the worksheet. I use a command button on the Userform (frmSHLDRProc) and the following code to try to show a worksheet named Table15-5...
Am I way off base? How do I show the worksheet. Returning to the Userform works fine.
Thanks for any help.
Bookmarks