LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 400
Default Macros: Why 'wbook.xls'!MyMacro

I have never seen this befo

In my workbook wbook.xls (Excel XP) I have several macros. On Tools | Macro
| Macros, a dialogue comes up showing the available macros. One of the macros
MyMacro is listed as 'wbook.xls'!MyMacro and selecting it does NOT enable the
Run button. The Run button does get enabled with the other macros - all of
them are in the Worksheet and are listed as ThisWorkbook.MyMacro(n).

However, after Alt + F11, I can step through MyMacro.

There is no open dialogue or error message, no formulaes in the workbook,
and there is no cell editing in progress.

I am completely baffled by this: can someone explain what is happening?

Thanks.
 
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
Progress Bar Macro Incorporated Into MyMacro ryguy7272 Excel Programming 5 October 12th 07 02:13 PM
functions in 'personal.xls' Russ Excel Programming 4 June 28th 07 10:10 PM


All times are GMT +1. The time now is 09:14 PM.

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

About Us

"It's about Microsoft Excel"