Prompted for VBA password when closing Excel with "Lotus Notes Qui
ben,
I had same problem with my VBA project. My problem was due to using the SET
statement to assign a reference to Thisworkbook.
eg:
Set mybook = Thisworkbook
what I neglected to do at then end of the procedure was add:
Set mybook = Nothing
This line solved my problem.
hope of some help to you.
--
JB
"Ben" wrote:
Hi, can anybody help me on this?
I have a protected Excel file, when I have installed "Lotus Notes QuickR"
and try to close the Excel file I was prompted to provide the VBA password.
Thanks.
|