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

tesoke · #5 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.

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