make user form stay open while going to other pages but hide when i go to other sheet

You should be able to use the Worksheet_Activate event, but you will have to put it in each worksheet (unless you want to get into classes, a bit harder). Something like:

Please Login or Register  to view this content.

on the worksheet where you want to show it, and

Please Login or Register  to view this content.

on the rest of the worksheets. This code would be pasted directly into each worksheet's module.

You can use additional code in the worksheet event module to hide the userform when you deactivate the sheet, and when you activate the sheet again.
When you hide the userform, the information should still be maintained on it, when you reactivate the sheet, the userform information will still be there.

Please Login or Register  to view this content.

Didi you place the worksheet_activate and deactivate code in the worksheet module?