Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default How to arrange that macros are from THIS w/book?

Hi,
Trouble is:
When copying workbook to different location macros seem to remember old
workbook path.
Consequently I get errors if some workbook with macros isn't there any more.
What is the cure? I am able to use VBA code for this, if necessary.
TIA
Paul


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default How to arrange that macros are from THIS w/book?

Hi Paul

Do you talk about the buttons that point to the macro in the old file

--
Regards Ron de Bruin
http://www.rondebruin.nl



"count" wrote in message ...
Hi,
Trouble is:
When copying workbook to different location macros seem to remember old workbook path.
Consequently I get errors if some workbook with macros isn't there any more.
What is the cure? I am able to use VBA code for this, if necessary.
TIA
Paul




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
what is the best book to learn macros indepth excel macros Excel Discussion (Misc queries) 4 April 19th 10 04:26 PM
Add-in AND Macros Not Showing Up in New Book SkyEyes Excel Discussion (Misc queries) 15 April 12th 07 04:38 PM
Autoload a book of macros ? Richard[_35_] Excel Programming 2 August 25th 05 04:00 PM
Open book, check for macros, close book Robin Hammond[_2_] Excel Programming 5 March 31st 05 06:09 PM
Macros - get information from Multiple sheets in a work book? matt Excel Programming 1 November 22nd 04 02:53 PM


All times are GMT +1. The time now is 04:03 AM.

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

About Us

"It's about Microsoft Excel"