Tab only visible to certain users

[surkdidat]

I have a tab that is opened by a Macro (password protected).

When the button is clicked, and the password is correct it opens a tab on the worksheet.

This is a shared workbook. Will this tab then become visible to anyone who has the workbook open, and if so, is there a way of having this only visible to whoever has entered the password)?

(appreciate I could simply have a linked workbook with a password protected name, but would rather have it all in one place if possible).

Thanks