#1   Report Post  
Marcin_71
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Marcin_71
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Marcin_71
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Marcin_71
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Editor closes Excel 2000 ? Rmontgo Excel Discussion (Misc queries) 0 July 16th 05 03:00 PM
passing arguments from an excel macro to a word macro KWE39 Excel Discussion (Misc queries) 1 July 7th 05 03:56 PM
Excel macro that opens new MS Word file and pastes data as a pictu Rob Excel Worksheet Functions 0 July 6th 05 05:12 PM
Excel XP 2002 Vs. Excel 2000 Samantha Excel Discussion (Misc queries) 0 April 18th 05 03:54 PM
Excel 2003 V's Excel 2000? Ket Excel Worksheet Functions 2 March 9th 05 12:05 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"