hi, i am trying to change the link source of a file with another file but my code below doesn't work, presumably because the file has a warning on top that says, "SECURITY WARNING Automatic update of links had been disabled."
What code would temporarily bypass that and let the change link code work? thx.
Please Login or Register to view this content.
This is bordering on break our rule 7...
7. Do not inquire about breaking the security of a protected workbook.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
oh. didn't know that. then what code will let me change the source location of the new file or to the active directory. right now it is pointing to the desktop but i don't store files there.
Good morning charliec
From the workbook containing the links, go to Data > Edit Links and click on the Startup Prompt box.
This should give you three options as to how the workbook links are handled when the file is opened. You probably want the first or the third option.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
thx. i'll take a look at it and may have to rephrase the question in a separate post if it doesn't work right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks