How do you start a Macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
THANK YOU!!! THANK YOU!!! THANK YOU!!!
This was about to drive me nuts. MS needs to make this much easier to figure
out or ask you during set up if you will be using macros.

Thanks!
Chris in Little Rock
 
Good information but I still have two questions.

1) I went to Alt+F8 and typed in a macro and clicked Create. When I ended
up on the next screen (Visual Basic), I saw two lines of programming language
but was not allowed to type in what I assume might be my keystroke command.
So what do you type in the second screen after Create and how?

2) I created a macro several weeks ago (now I wonder how I did it!) and
want to delete it. It seems that the Help menu Delete information is all
about security, digital signatures, Visual Basic, etc. Macros now seem to be
more about the security of receiving documents with macros in them rather
than the simple creation of a macro for a letter closing, for example. So,
when I go to Developer, Macros, etc. and get to the screens with Delete on
them, the command is grayed out and I cannot use it. Although the macro is
working in Excel, I dont' see it listed anywhere as a macro. Help!!
 
Peo Sjoblom said:
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
Click to expand...
 
Peo Sjoblom said:
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
Click to expand...
 
How does one import macros previously written in excel 2003 into excel 2007?
Thanks very much in advance.
 
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
 
Back
Top