Hello,
I have an Excel VBA app in which an open VBA workbook opens via automation
another Workbook and copies into it some worksheets from it per below:

For ndx = 3 To Workbooks("Quotes.xls").Worksheets.Count
Workbooks("Quotes.xls").Activate
Workbooks("Quotes.xls").Worksheets(ndx).Copy
After:=Workbooks(strFileNm).Worksheets(Workbooks(s trFileNm).Worksheets.Count
Next ndx

The code for both books is password protected and previously there was no
problem copying the worksheets from the first into the latter. But now when
the above code is performed, the prompt to enter the VBA Project password to
unlock the code comes up, which it didn't do before.
Any ideas what may have caused the change? I don't use this routine a lot
but the app was originally functioning under Office 2000, and now is under
Office/Excel 2003-did something change in the 2003?
Thanks, God bless
Van

I don't see anything in your code that would do this.

Maybe it's not excel.

There was a problem a few months ago with google desktop. IIRC, it would try to
index the project while the workbook was open and cause the password to the
project to pop up.

Do you have any of those type programs running? (MSN has a version, too.)

(That was a complete guess, though.)

If that doesn't work, I'd try disabling the antivirus software--an even more
complete guess!

VanS wrote:

Hello,
I have an Excel VBA app in which an open VBA workbook opens via automation
another Workbook and copies into it some worksheets from it per below:

For ndx = 3 To Workbooks("Quotes.xls").Worksheets.Count
Workbooks("Quotes.xls").Activate
Workbooks("Quotes.xls").Worksheets(ndx).Copy
After:=Workbooks(strFileNm).Worksheets(Workbooks(s trFileNm).Worksheets.Count
Next ndx

The code for both books is password protected and previously there was no
problem copying the worksheets from the first into the latter. But now when
the above code is performed, the prompt to enter the VBA Project password to
unlock the code comes up, which it didn't do before.
Any ideas what may have caused the change? I don't use this routine a lot
but the app was originally functioning under Office 2000, and now is under
Office/Excel 2003-did something change in the 2003?
Thanks, God bless
Van

--

Dave Peterson

Dave,
Thanks for your reply.I don't have the Google app. But I tried something and
it worked for some reason I don't fully understand.
Thanks again, God bless
Van S. Mabrito
"Dave Peterson" wrote:

I don't see anything in your code that would do this.

Maybe it's not excel.

There was a problem a few months ago with google desktop. IIRC, it would try to
index the project while the workbook was open and cause the password to the
project to pop up.

Do you have any of those type programs running? (MSN has a version, too.)

(That was a complete guess, though.)

If that doesn't work, I'd try disabling the antivirus software--an even more
complete guess!

VanS wrote:

Hello,
I have an Excel VBA app in which an open VBA workbook opens via automation
another Workbook and copies into it some worksheets from it per below:

For ndx = 3 To Workbooks("Quotes.xls").Worksheets.Count
Workbooks("Quotes.xls").Activate
Workbooks("Quotes.xls").Worksheets(ndx).Copy
After:=Workbooks(strFileNm).Worksheets(Workbooks(s trFileNm).Worksheets.Count
Next ndx

The code for both books is password protected and previously there was no
problem copying the worksheets from the first into the latter. But now when
the above code is performed, the prompt to enter the VBA Project password to
unlock the code comes up, which it didn't do before.
Any ideas what may have caused the change? I don't use this routine a lot
but the app was originally functioning under Office 2000, and now is under
Office/Excel 2003-did something change in the 2003?
Thanks, God bless
Van

--

Dave Peterson