Prevent copy / get data from hidden sheet

[Senthil Murugan]

Good Evening to all

Prevent copy / get data from hidden sheet

Situation

My xlveryhidden sheet name is "LOGIN PASSWORD" & Sheet is password protected and Workbook structure protected

I have data in A1 in "LOGIN PASSWORD" Sheet as "12345LQ"

if I put formula from any other sheet like =LOGIN PASSWORD!A1

It shows 12345LQ

How to prevent it from showing 12345LQ


Thanks in advance

A.Senthil Murugan

 

[Fluff]

As far as I know, you cannot stop someone from doing that.

 

[HighAndWilder]

Good Evening to all

Prevent copy / get data from hidden sheet

Situation

My xlveryhidden sheet name is "LOGIN PASSWORD" & Sheet is password protected and Workbook structure protected

I have data in A1 in "LOGIN PASSWORD" Sheet as "12345LQ"

if I put formula from any other sheet like =LOGIN PASSWORD!A1

It shows 12345LQ

How to prevent it from showing 12345LQ


Thanks in advance

A.Senthil Murugan

If you have data in a sheet that you do not want users to have access to then why put the sheet in the workbook?

 

[Senthil Murugan]

If you have data in a sheet that you do not want users to have access to then why put the sheet in the workbook?

Sir,
I have no. of sheets , each sheet has password protected to open by specific user to update their data ,which others do not open

the username and password have been stored in the xlveryhidden sheet , using login userform with username and password


with regards


A.Senthil Murugan

 

[Senthil Murugan]

As far as I know, you cannot stop someone from doing that.

Thank you Mr.Fluff for your reply

 

[Fluff]

If your using that in VBA, why not hard code the passwords in the macro, rather than putting them on a sheet?