Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default List Active Macros?

I am starting to get into a state of macro bulge. I have a Public WB and a
Private WB, each with several macros in it. In addition some of my active WBs
have quite a few of their own macros.

Is there any way to list (print) the surrent active macros? Also is there
any way to list the surrently assigned hotkeys among the active macros?
--
Dave
Temping with Staffmark
in Rock Hill, SC
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default List Active Macros?

This .xla add-in:
http://tinyurl.com/rrw3p
Has an extensive workbook documenter and it will amongst many
other things list all your macro's.

RBS


"Dave Birley" wrote in message
...
I am starting to get into a state of macro bulge. I have a Public WB and a
Private WB, each with several macros in it. In addition some of my active
WBs
have quite a few of their own macros.

Is there any way to list (print) the surrent active macros? Also is there
any way to list the surrently assigned hotkeys among the active macros?
--
Dave
Temping with Staffmark
in Rock Hill, SC


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default List Active Macros?

Even if that didn't do the trick, the collection is well worth the trip!
Thanks.
--
Dave
Temping with Staffmark
in Rock Hill, SC


"RB Smissaert" wrote:

This .xla add-in:
http://tinyurl.com/rrw3p
Has an extensive workbook documenter and it will amongst many
other things list all your macro's.

RBS


"Dave Birley" wrote in message
...
I am starting to get into a state of macro bulge. I have a Public WB and a
Private WB, each with several macros in it. In addition some of my active
WBs
have quite a few of their own macros.

Is there any way to list (print) the surrent active macros? Also is there
any way to list the surrently assigned hotkeys among the active macros?
--
Dave
Temping with Staffmark
in Rock Hill, SC



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
to change the macros as per active cell and range pol Excel Discussion (Misc queries) 2 August 4th 09 01:19 PM
Active Content/Macros Canon Excel Discussion (Misc queries) 2 June 4th 09 12:57 PM
how to list all active macros and their assigned keystrokes? z.entropic Excel Worksheet Functions 2 October 5th 07 03:29 PM
In macros, an instruction that will return the position of the Active Cell aca[_4_] Excel Programming 2 January 20th 06 10:50 PM
Check active sheet not the one with macros Oscar Excel Programming 2 July 30th 04 04:32 PM


All times are GMT +1. The time now is 04:53 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"