View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Can't you unshare the workbook first, then run J.E.'s code to unprotect the
workbook?

Thore wrote:

Good morning all,
I have a shared workbook which is protected with a password. Now I would
like to make a copy of the file and remove the "shared" function as well as
the password. Unfortunately I do not have access to the password.
I have the tried the http://mcgimpsey.com/excel/removepwords.html password
remover, but it does work for share protection. Any suggestions?
Btw, I am working with Excel2000 (SP3)
Brgds & thx in advance, Thore


--

Dave Peterson