View Single Post
 
Old 11-15-2021, 05:02 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you are being asked about over-writing a macro then it is a pretty clear indication that a macro with the same name is already in the module where you are trying to save it.

However, not EVERY macro will appear in the list of macros to run - for instance Functions or Subs which take inputs won't show in your list since they need to be called from other Subs or Functions.

Your screen caps show the Normal.NewMacros1.FindSamePla... pair of macros are not in the list without the template.module.macro hierarchy. My first suspicion is that you actually have multiple templates active and the code modules are similar but not exactly the same in both. If you have verified that not to be the case then I would look at the full macro names and try to work out what is special about those two macros. It might also be that one of the lists is not sorted alphabetically and those macros appear somewhere else in the list.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote