Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy w/o Creating Link in Excel 2007
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |