Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
i created a macro in a spreadsheet...then killed it. however, now every time i open the spreadsheet i get the message asking whether or not i want to enable macros...how do i get rid of this? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
You also have to delete the module where the macro was located.
-- Sincerely, Michael Colvin "bcamp1973" wrote: i created a macro in a spreadsheet...then killed it. however, now every time i open the spreadsheet i get the message asking whether or not i want to enable macros...how do i get rid of this? -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
what is a module? Michael Wrote: You also have to delete the module where the macro was located. -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
Hi bcamp1973. If you go to tools - macros - visual basic editor you'll see
the modules in the left hand frame. However, please don't just start removing modules until someone more familiar with the process responds to your question. I am unqualified to give VBA advice. Sorry I couldn't be more helpful. -- Sincerely, Michael Colvin "bcamp1973" wrote: what is a module? Michael Wrote: You also have to delete the module where the macro was located. -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
Thanks Michael, that was actually helpful...in my mucking about to create a macro i created a module (which i then forgot about) but i saw it in the list and deleted it. No longer an issue... Thanks! Brian Michael Wrote: Hi bcamp1973. If you go to tools - macros - visual basic editor you'll see the modules in the left hand frame. However, please don't just start removing modules until someone more familiar with the process responds to your question. I am unqualified to give VBA advice. Sorry I couldn't be more helpful. -- Sincerely, Michael Colvin -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
kill "enable macros" message
That's great, bcamp1973.
-- Sincerely, Michael Colvin "bcamp1973" wrote: Thanks Michael, that was actually helpful...in my mucking about to create a macro i created a module (which i then forgot about) but i saw it in the list and deleted it. No longer an issue... Thanks! Brian Michael Wrote: Hi bcamp1973. If you go to tools - macros - visual basic editor you'll see the modules in the left hand frame. However, please don't just start removing modules until someone more familiar with the process responds to your question. I am unqualified to give VBA advice. Sorry I couldn't be more helpful. -- Sincerely, Michael Colvin -- bcamp1973 ------------------------------------------------------------------------ bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268 View this thread: http://www.excelforum.com/showthread...hreadid=522880 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the last sonic message of OUSSAMA BEN LADEN | Excel Discussion (Misc queries) | |||
the last sonic message of OUSSAMA BEN LADEN | Excel Discussion (Misc queries) | |||
Error message when using Pivot Table | Excel Discussion (Misc queries) | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) |