Protect sheet without password?
 

Hello,
Can I protect individual sheets without a password? I'd like for
individuals to only be able to view the sheet that's pertinent to him/her.

I understand that if you forget the password, you're had.

Thanks,
Ellen

Protect sheet without password?
 

In general terms -- Not that I know of

A possible solution is via the ThisWorkbook object to create a login for
your user
and hide all sheets but there sheet/sheets.

But this is far from secure

"EllenM" wrote:

Hello,
Can I protect individual sheets without a password? I'd like for
individuals to only be able to view the sheet that's pertinent to him/her.

I understand that if you forget the password, you're had.

Thanks,
Ellen

Protect sheet without password?
 

I thought as much. Just wanted to get confirmation.

Thanks!

"steve_doc" wrote:

In general terms -- Not that I know of

A possible solution is via the ThisWorkbook object to create a login for
your user
and hide all sheets but there sheet/sheets.

But this is far from secure

"EllenM" wrote:

Hello,
Can I protect individual sheets without a password? I'd like for
individuals to only be able to view the sheet that's pertinent to him/her.

I understand that if you forget the password, you're had.

Thanks,
Ellen