View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zeon zeon is offline
external usenet poster
 
Posts: 2
Default Record a macro which enters a password to unprotect a workbook

Hi,

Please can someone help. I have a few workbooks that has been protected via
Save as\Tools\General options\Password to open.

I want to record/edit a macro to open and enter the passwords for all the
workbooks, but when I record the macro, it ignore the fact that I am typing
in a password, how do I get around this?

Many Thanks

Zeon.