View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VanS[_2_] VanS[_2_] is offline
external usenet poster
 
Posts: 60
Default Excel app now requires password

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