View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
steve_doc steve_doc is offline
external usenet poster
 
Posts: 140
Default 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