LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default make macro run other macros in Exc 2007,no problems in Exc 2003

Hi,

I suspect the problem is that Excel 2007 won't let any macros run until you
click the Security Bar Options button and choose to Enable content. This is
a new security feature in 2007.

As an aside:

Since each button is a macro, the common way to do this is to write code
such as this:
Sub Master()
myProd1
myProd2
myProd3
End sub

Where myProd1 in the name of one procedure (macro)

You can put this in the thisWorkbook object as
Workbook_Open()
myProd1
myProd2
myProd3
End sub


If any of this helps, please click the Yes button.

thisWorkbook object if you want it to run when you first open Excel

--
Thanks,
Shane Devenshire


"SteveB" wrote:

In Excel 97/2003 I can make one macro start other macros by having it click
each macro button created, but I cannot seem to be able to do this in Excel
2007.
Would appreciate any help on this please.

 
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
2003-2007 File conversion problems Harimau Excel Discussion (Misc queries) 0 June 26th 08 01:51 AM
Excell 2007 to 2003 problems tjanson Excel Discussion (Misc queries) 0 February 23rd 08 04:20 AM
Excel Macros from 2003 to 2007 brihyanna Excel Discussion (Misc queries) 1 December 14th 07 03:29 PM
2003--2007 convert problems Miri Excel Discussion (Misc queries) 0 October 2nd 07 02:17 PM
Excel 2007 problems w/Saves As 97-2003 maddiesdad Excel Discussion (Misc queries) 0 September 25th 07 06:26 PM


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