Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Change Excel Link Source using VBA for Excel 2007


One possible reason is you are getting an error in your macro. Try
chage the Break on Error setting as shown below. the re-run the macro

From VBA menu
1) Tools - Options - general
2) Error Trapping - "Break on all Errors"


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=207656

http://www.thecodecage.com/forumz


--- news://freenews.netfront.net/ - complaints: ---
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table-Change Data Source? Excel 2007 srpd Charts and Charting in Excel 1 May 20th 10 02:15 PM
Excel 2007 - Change link source requiring multiple entry of passwo Glen Miller Excel Worksheet Functions 0 December 4th 09 09:06 AM
Excel 2007 change pivot data source bdub Excel Discussion (Misc queries) 4 August 13th 07 07:54 PM
Excel 2007 change data source Bart Excel Discussion (Misc queries) 1 October 4th 06 11:19 AM
How change link source in long formula when source moved Irina Excel Programming 4 June 28th 06 07:27 AM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"