View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JEFFRO JEFFRO is offline
external usenet poster
 
Posts: 3
Default Protected Workbook

I have code that calls a workbook that I once protected,
but cannot get it to save as unprotected. Now, when the
macro calls this workbook to open, I get prompted for the
password. How do I get this workbook to save as
unprotected so I don't have to enter a password 100 times
(yes, I went to Tools\Protection\Protect
Workbook\Unprotect Workbook\Save)?

TIA!!!!