View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do you start a Macro?

Depends upon where the macros are currently located.

In a single workbook? Open that workbook in 2007 and save as *.xlsm

In multiple workbooks?

In Personal.xls?

In an Add-in?

You want to import the modules into an existing workbook in 2007?

Do you want the macros to available for all workbooks in 2007?


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 13:00:01 -0800, Ldog
wrote:

How does one import macros previously written in excel 2003 into excel 2007?
Thanks very much in advance.

"Peter K In Whitby ON" wrote:



"Peo Sjoblom" wrote:

What version? If you mean 2007 you can use shortcut Alt + F8, or you can go
to the developer tab and click on the macro button and run them from there.
To get the developer tab, click the office icon (tope left), click excel
options, select personalize in the top left corner and make sure "Show
developer tab in the ribbon" is selected

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
Well explained! Thanks for the thoughtful assistance.


PK

"Michael" wrote in message
...
The thing that I am wondering the most is how to start a macros. Adding
on
to that question where is the tools menu to start the macros? This
version
of Office is completely different from the others.