PC Review


Reply
Thread Tools Rate Thread

How do you start a Macro?

 
 
=?Utf-8?B?TWljaGFlbA==?=
Guest
Posts: n/a
 
      4th Jun 2006
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.
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      4th Jun 2006
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


"Michael" <(E-Mail Removed)> wrote in message
news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> 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.



 
Reply With Quote
 
=?Utf-8?B?Q2hyaXMgaW4gTGl0dGxlIFJvY2s=?=
Guest
Posts: n/a
 
      13th Jun 2006
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

"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
>
>
> "Michael" <(E-Mail Removed)> wrote in message
> news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> > 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.

>
>
>

 
Reply With Quote
 
JWKing
Guest
Posts: n/a
 
      18th Aug 2008
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" 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
>
>
> "Michael" <(E-Mail Removed)> wrote in message
> news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> > 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.

>
>
>

 
Reply With Quote
 
Peter K In Whitby ON
Guest
Posts: n/a
 
      15th Feb 2010


"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
>
>
> "Michael" <(E-Mail Removed)> wrote in message
> news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> > 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.

>
>
>

 
Reply With Quote
 
Peter K In Whitby ON
Guest
Posts: n/a
 
      15th Feb 2010


"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" <(E-Mail Removed)> wrote in message
> news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> > 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.

>
>
>

 
Reply With Quote
 
Ldog
Guest
Posts: n/a
 
      26th Feb 2010
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" <(E-Mail Removed)> wrote in message
> > news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
> > > 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.

> >
> >
> >

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      27th Feb 2010
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 <(E-Mail Removed)>
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" <(E-Mail Removed)> wrote in message
>> > news:054BFBC1-ECE3-4E65-9506-(E-Mail Removed)...
>> > > 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.
>> >
>> >
>> >


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 - open .xls file and start macro or start file and go to specific cell Newsgroups Microsoft Excel Discussion 1 7th Aug 2007 02:51 AM
Sub Macro vrs Function Macro Auto Start =?Utf-8?B?UGF0?= Microsoft Excel Misc 7 6th Jun 2007 09:53 PM
Macro Start =?Utf-8?B?emVwaHly?= Microsoft Excel Misc 0 13th Nov 2006 05:01 PM
Start Macro / Stop Macro / Restart Macro Pete Microsoft Excel Programming 2 21st Nov 2003 05:04 PM
Can I start a macro using a # key? Ftca Microsoft Excel Programming 2 13th Oct 2003 04:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:03 PM.