View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpov dpov is offline
external usenet poster
 
Posts: 2
Default password protection problem

I have a user who sent me a spreadsheet that was uneditiable. At first, the
macros were not enabled so the whole spreadsheet could not be seen in the
Excel window. Once I enabled the macros, the spreadsheet could expand to
fill the application window, but the cells were still password protected.

I sent the spreadsheet back to the user explaining that he would have to
have the password in order to unlock and edit the cells. It turns out that
the original user who first sent me the spread sheet is able to edit the
cells on his PC without a password. However, when the sheet is sent to other
users, the cells are still protected and locked. I thought maybe the
password was somehow associated with his Windows password, but that does not
work to unlock

Would someone please assist me with this mystery?

Thank you
--
Dave