Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2007 always links to the original workbook when it's copied,
regardless of how it's copied! There are no links in the original. Since the original is double-password protected, the copy not only asks for its own two passwords, but also one from the original. Once it's open, I find no reference to the original, even though there's now one link to the original listed. I need to do the copy via VBA, and I have no problem providing the appropriate two passwords there. However, I don't know how to provide the password for this ghostly original, since at least then I could delete the link via VBA. The procedure now stops there, shows the hidden Excel, and asks for a password. It never did this in Excel 2003. I've searched everywhere I can think of and found no references to the file name. I've tried SaveCopyAs, FileCopy, copying in Explorer, even DOS! Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Forms in Excel 2007 | Excel Worksheet Functions | |||
Creating Images in Excel 2007 | Excel Discussion (Misc queries) | |||
Creating Forms with Excel 2007 | New Users to Excel | |||
Excel 2007 and creating Forms | Excel Discussion (Misc queries) | |||
Creating a virtual link in Excel | Excel Discussion (Misc queries) |