J
jbclem
Recently, when I open a spreadsheet (that I use daily) I'm getting an Excel
window/message stating that the spreadsheet contains macros and asking me
whether I want to disable or enable them. I haven't created any macros, but
I have pasted in text from various web sites, so possibly a macro has come
with the paste operation.
How can I find a listing of macros in this spreadsheet so I can troubleshoot
this problem. When I go to Tools/Macro/Macros, the window opens up with a
"macro name" but the window is of fixed size and since the spreadsheet name
is long I can't read the entire "macro name", so this is useless. And I'm
not going to run the macro until I know what it is, and don't seem to have a
way to view the name of the macro.
Can someone suggest a way to do this...
Thanks,
jc
window/message stating that the spreadsheet contains macros and asking me
whether I want to disable or enable them. I haven't created any macros, but
I have pasted in text from various web sites, so possibly a macro has come
with the paste operation.
How can I find a listing of macros in this spreadsheet so I can troubleshoot
this problem. When I go to Tools/Macro/Macros, the window opens up with a
"macro name" but the window is of fixed size and since the spreadsheet name
is long I can't read the entire "macro name", so this is useless. And I'm
not going to run the macro until I know what it is, and don't seem to have a
way to view the name of the macro.
Can someone suggest a way to do this...
Thanks,
jc