StrangeLuck
New Member
- Joined
- Mar 25, 2002
- Messages
- 15
Hello,
I have written a macro to automate some monotonous tasks. One of the workbooks opened by the macro is password protected. In the VBA of my macro, I open the workbook using the line
Workbooks.Open FileName:="filename.xls"
and enter the password at the prompt. No problem so far, hmm?
The problem occurs when changes have been made to this workbook by the macro and I want to save it and close it. Excel tells me now that the workbook is opened as "Read-Only" and I cannot save it.
Any suggestions?
Thanks,
StrangeLuck
I have written a macro to automate some monotonous tasks. One of the workbooks opened by the macro is password protected. In the VBA of my macro, I open the workbook using the line
Workbooks.Open FileName:="filename.xls"
and enter the password at the prompt. No problem so far, hmm?
The problem occurs when changes have been made to this workbook by the macro and I want to save it and close it. Excel tells me now that the workbook is opened as "Read-Only" and I cannot save it.
Any suggestions?
Thanks,
StrangeLuck