| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to External "Password Protected" Worksheet
I am linking to a cell in a protected worksheet to retrieve the data in that
cell. The command I am using is ='D:\directory\[spreadsheet name.xls]Actuals'!$F$369. Is there a way that I can embed the password into this command so that the pop-up window doesn't always appear and request the password be typed in? Thanks, Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter set to "SHOW ALL" on open for a protected worksheet | Excel Discussion (Misc queries) | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Password-Protected Workbook not showing "in use by another user" | Excel Discussion (Misc queries) | |||
| "Show all" button not work in protected worksheet | Excel Worksheet Functions | |||
| How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
