Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,069
Default NUMBER OF MACROS

In Excel 2007, is there a limit of macros you can assign to a worksheet? If
not, how do I increase the setting. I need at least 16 and it seems to only
allow 14.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,069
Default NUMBER OF MACROS

I just noticed Excel sorted the names and I thought they were lost.

"JOHN" wrote:

In Excel 2007, is there a limit of macros you can assign to a worksheet? If
not, how do I increase the setting. I need at least 16 and it seems to only
allow 14.

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 857
Default NUMBER OF MACROS

When you say lost, what do you mean exactly? This question needs some
clarification. What do you mean by assign a macro to a worksheet? Where are
you getting the number 14?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JOHN" wrote:

In Excel 2007, is there a limit of macros you can assign to a worksheet? If
not, how do I increase the setting. I need at least 16 and it seems to only
allow 14.

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,069
Default NUMBER OF MACROS

Shane, thank you for inquiring but it seems I jumped the gun. I asked the
question without realizing that Excel just sorted the names of the macros and
I thought I lost them.

"Shane Devenshire" wrote:

When you say lost, what do you mean exactly? This question needs some
clarification. What do you mean by assign a macro to a worksheet? Where are
you getting the number 14?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JOHN" wrote:

In Excel 2007, is there a limit of macros you can assign to a worksheet? If
not, how do I increase the setting. I need at least 16 and it seems to only
allow 14.

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
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros warning always shows up, even if all macros removed Joe M Excel Discussion (Misc queries) 1 December 20th 07 04:45 AM
Macros - copying macros from one computer to another TT Excel Discussion (Misc queries) 18 December 14th 06 03:24 AM
Macros fill cells regardless of row number Trixie Excel Discussion (Misc queries) 7 March 24th 06 11:41 AM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM


All times are GMT +1. The time now is 11:22 AM.

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"