View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Newman Bob Newman is offline
external usenet poster
 
Posts: 40
Default Password removal?

I have a 2007 workbook password protected. When someone tries to open the
file a box comes up giving the option of putting in my password for full
access including editing or just clicking a button to open the file as read
only. I do have the password, there is no problem there. I would like to
remove the requorement to put in a password though and have the file open
normally. I am still trying to get used to 2007's menu structure. I click
Format/Protect Sheet and uncheck the box that says "Protect worksheet and
contents of locked cells" when I do this the OK box goes dim and doesn't
allow me to select it. Help please.

Thanks in advance... Bob