Create Login User Form with Multiple User

[jaylyn_cpa]

Good day, I want to start a new project in Excel using VBA and I want to put Login Userform.
What i want is only sheet given to certain user is only visible and other sheet is hidden.
Can you help me.

Thanks in Advanced.

[Trebor76]

Hi jaylyn_cpa,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[jaylyn_cpa]

It is working fine, Thanks for this,
but how can i hide all sheets before logging in?

[Trebor76]

but how can i hide all sheets before logging in?

There must be at least one visible tab in any workbook. This event macro* will hide all sheets except for "Login Page" whenever the workbook is opened as I think that's what you're after:

Please Login or Register  to view this content.

Regards,

Robert

* This event macro must be placed on ThisWorkbook not in a standard module