Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protected workbook
In a macro I have it opens a workbook that is password protected. I would
like the macro to accept the Read Only option, without me having to actually click on the prompt. Is this possible? The DisplayAlert command doesn't seem to work (unless I'm using it wrong). Thanks very much as always!! Kelley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protected workbook
Hi
Open the workbook as ReadOnly by default: Workbooks.Open Filename:="MyFile.xls", ReadOnly:=True Hopes this helps. --- Per "Kell2604" skrev i meddelelsen ... In a macro I have it opens a workbook that is password protected. I would like the macro to accept the Read Only option, without me having to actually click on the prompt. Is this possible? The DisplayAlert command doesn't seem to work (unless I'm using it wrong). Thanks very much as always!! Kelley |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protected workbook
Hi Kell,
Maybe you can try this one: Sub TestReadonly() Application.DisplayAlerts = False Workbook.open "C:\Yourbook.xls" end sub -- Regards, Halim "Kell2604" wrote: In a macro I have it opens a workbook that is password protected. I would like the macro to accept the Read Only option, without me having to actually click on the prompt. Is this possible? The DisplayAlert command doesn't seem to work (unless I'm using it wrong). Thanks very much as always!! Kelley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protected workbook | Excel Discussion (Misc queries) | |||
password protected workbook | Excel Worksheet Functions | |||
Password protected workbook | Excel Programming | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |