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 ??

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 ??

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 ??

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 ??

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 ??

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

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