D
Double Dumbass On You
I had three different normal.dot files, each with about 25-30 macros. Many
were duplicates. I merged the macro code manually and deleted two of the
normal.dot files so that I would have one master file with ALL of the
macros. I assumed there would be some sort of cleanup mechanism that would
allow me to quickly and easily remove the duplicate macros, or, that they
would appear in the Tools>Macro>Macros list so I could just use Delete to
get rid of them. However, the duplicate macros only appear in the list
once. This is a serious problem because everytime I want to execute ANY
macro, I get errors about all the duplicates. It says that the name is
ambiguous. If I delete two of the three sections of code for the duplicate
it was complaining about and try to run a macro again, it moves to the next
duplicate in the list and complains about the ambiguous name. I guess it
compiles the whole sheet at runtime.
Is there some way in the MS Visual Basic Editor (invoked by Word, et al.) to
remove the duplicates? Is there a way to compile the macro sheet and check
for errors?
were duplicates. I merged the macro code manually and deleted two of the
normal.dot files so that I would have one master file with ALL of the
macros. I assumed there would be some sort of cleanup mechanism that would
allow me to quickly and easily remove the duplicate macros, or, that they
would appear in the Tools>Macro>Macros list so I could just use Delete to
get rid of them. However, the duplicate macros only appear in the list
once. This is a serious problem because everytime I want to execute ANY
macro, I get errors about all the duplicates. It says that the name is
ambiguous. If I delete two of the three sections of code for the duplicate
it was complaining about and try to run a macro again, it moves to the next
duplicate in the list and complains about the ambiguous name. I guess it
compiles the whole sheet at runtime.
Is there some way in the MS Visual Basic Editor (invoked by Word, et al.) to
remove the duplicates? Is there a way to compile the macro sheet and check
for errors?