Thread: Security
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dwake dwake is offline
external usenet poster
 
Posts: 41
Default Security

I have a couple of questions. I want to protect a workbook, but grant access
to a person to edit one sheet in the workbook. I do not want him to have the
password. I can't seem to find a way to allow him write access without
unprotecting the workbook. I than have to protect each individual sheet, and
grant him access to write going that route.

I am also having problems opening a group and outline tab while a worksheet
is protected.

Anyway around these? Any advice would be appreciated.