ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to bypass password pop up alert (https://www.excelbanter.com/excel-programming/312189-macro-bypass-password-pop-up-alert.html)

No Name

Macro to bypass password pop up alert
 
Is it possible for a macro that can bypass a password pop
up window when opening another spreadsheet, which will
automatically read only so that the macro does not get
interrupted.

Any help would be awesome, thanks.

Tom Ogilvy

Macro to bypass password pop up alert
 
Supply the password as part of the workbook.Open command.

--
Regards,
Tom Ogilvy

wrote in message
...
Is it possible for a macro that can bypass a password pop
up window when opening another spreadsheet, which will
automatically read only so that the macro does not get
interrupted.

Any help would be awesome, thanks.





All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com