password protect to view sheets without affecting connection

Hi

I want to hide a sheet, so that the user would be able to view it after entering a password. this is as I have data that the user should be able to view alone.

I know I can just add a password protection, but I have a get data from that excel file (power query connection) that pulls data from that spreadsheet into another spreadsheet and if I add a password to it, it will mess up the connection.

Can anyone help me add a protection (welcome sheet asking for password to view remaining sheets) but not affecting the connection at the same time.

Try such code in Thisworkbook module.
You shall have WELCOME SCREEN sheet in the workbook (can be normally hidden or very hidden).
It wouild be wise also to add Workbook BeforeSave event handler that (when workbook is opened with a password and worked normally) it saves it with only Welcome Screen sheet visible and other sheets hidden

Please Login or Register  to view this content.

For the time of the preparation of the query you need all sheets visible.
Then, once query has been set up, it will work (refresh) even with hidden sheets.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.