keep asking for the password....

[daveyc18]

    Sheets("IE").Select
    
 
    Cells.Copy
    
    ThisWorkbook.Sheets("ie").Activate
    
    
    Range("a1").PasteSpecial xlPasteValues

when it tries to paste the data, excel asks for the password (the source data file sheets are password protected). The thing is, if I dont enter a password and click ok or cancel, the data ends up getting pasted anyway

any way to bypass this alert?

 

[Scott Huish]

Personally, I would provide the password via code, but perhaps:
Application.DisplayAlerts=False

Be sure and set it to True when you're done

 

[daveyc18]

Personally, I would provide the password via code, but perhaps:
Application.DisplayAlerts=False

Be sure and set it to True when you're done

I have display alerts as false

the VBA code does successfully enter the password when the workbook is opened

but it seems to ask for the password when i try to paste the data to the destination workbook

now i don't know if it's asking for the workbook password or its the protected-sheet password as the dialog box is cut off ...my guess is protected sheet, but wouldn't that be asked when you're trying to type something on the protected sheet