Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro in Excel 2000
During opening Excel file is displaying message about contains macro.
Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? |
#2
|
|||
|
|||
Go to the VB IDE (Alt-F11)
If the workbook has modules, select it, then remove it (FileRemove Module1). Say no to exporting. Then click on ThisWorkbook, and each Sheet listed to see if there is any code there, if so delete it. -- HTH Bob Phillips "Marcin_71" wrote in message ... During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? |
#3
|
|||
|
|||
I'm checked workbook and it don't has any modules.
Whot can I do ?? €˛Bob Phillips€¯ pisze: Go to the VB IDE (Alt-F11) If the workbook has modules, select it, then remove it (FileRemove Module1). Say no to exporting. Then click on ThisWorkbook, and each Sheet listed to see if there is any code there, if so delete it. -- HTH Bob Phillips "Marcin_71" wrote in message ... During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? |
#4
|
|||
|
|||
And the others?
-- HTH RP (remove nothere from the email address if mailing direct) "Marcin_71" wrote in message ... I'm checked workbook and it don't has any modules. Whot can I do ?? "Bob Phillips" pisze: Go to the VB IDE (Alt-F11) If the workbook has modules, select it, then remove it (FileRemove Module1). Say no to exporting. Then click on ThisWorkbook, and each Sheet listed to see if there is any code there, if so delete it. -- HTH Bob Phillips "Marcin_71" wrote in message ... During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? |
#5
|
|||
|
|||
I checked all sheets and there are no any modules.
€˛Bob Phillips€¯ pisze: And the others? -- HTH RP (remove nothere from the email address if mailing direct) "Marcin_71" wrote in message ... I'm checked workbook and it don't has any modules. Whot can I do ?? "Bob Phillips" pisze: Go to the VB IDE (Alt-F11) If the workbook has modules, select it, then remove it (FileRemove Module1). Say no to exporting. Then click on ThisWorkbook, and each Sheet listed to see if there is any code there, if so delete it. -- HTH Bob Phillips "Marcin_71" wrote in message ... During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? |
#6
|
|||
|
|||
Debra Dalgleish has some instructions with pictures:
http://www.contextures.com/xlfaqMac.html#NoMacros Marcin_71 wrote: During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? -- Dave Peterson |
#7
|
|||
|
|||
Thanks You
Your link help me. Marcin €˛Dave Peterson€¯ pisze: Debra Dalgleish has some instructions with pictures: http://www.contextures.com/xlfaqMac.html#NoMacros Marcin_71 wrote: During opening Excel file is displaying message about contains macro. Excel give two posibility: open with or without macro. After opening with macro, I can't see it in macros list (Tools/Macro/Macros). How I can check this macro and how I can delete it ?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Editor closes Excel 2000 ? | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions |