Can we define macros in a way to not misworking after deleting, renaming or moving the source file?

Debaser · #1 11-11-2015, 02:51 AM

Quote:

Originally Posted by tesoke

1) Why macros do not work after deleting, renaming or moving the source file, which we define them in it?

Because the QAT contains a full path to the file containing the code and that is not updated when you rename the file.

Quote:

2) Is there any way to solve this problem? Can we define macros in a way to not misworking after deleting, renaming or moving the source file?

Yes - don't use the QAT. Customise the Ribbon using the CustomUI part of the workbook. That way all the customisation is stored in the workbook itself, not in a separate file as it is with the QAT.

tesoke · #2 11-11-2015, 03:13 PM

Thank you so much macropod and Debaser!

Quote:

Originally Posted by Debaser

Yes - don't use the QAT. Customise the Ribbon using the CustomUI part of the workbook. That way all the customisation is stored in the workbook itself, not in a separate file as it is with the QAT.

Would you please explain this way more. I am a newcomer and do not know much. I can work with macro only with clicking on Record Macro and Stop Macro! I do not know what is QAT and about programming in excel. I do not want to waste your time so much. If you say some notes I will navigate about them and find the solution.

Thanks again.

tesoke · #3 11-12-2015, 02:38 PM

Thank you macropod! I got what is QAT

Quote:

Originally Posted by Debaser

Yes - don't use the QAT. Customise the Ribbon using the CustomUI part of the workbook. That way all the customisation is stored in the workbook itself, not in a separate file as it is with the QAT.

Would you please explain what is Ribben, CustomUI and workbook? I think if you explain these, you will solve my problem. Thanks a lot.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macros to move objects prevents moving same objects with arrow keys	BruceM	Word VBA	1	03-10-2015 08:20 AM
Deleting and moving word documents	tenpasteight	Word	3	06-01-2014 11:10 AM
define a mail merge data source using unc (universal naming convention)	charlesandrews	Mail Merge	0	08-21-2012 10:33 AM
Deleting sections without formatting moving up	pamorrison	Word	1	04-20-2012 02:14 AM
truncating path or renaming audio file to play in powerpoint	rbookend	PowerPoint	0	05-02-2006 03:39 PM