Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel Macro Record Buttons

 
   Macintosh computer (Home) -> Excel RSS
Next:  Menu bar shows up twice  
Author Message
Spike Jones

External


Since: Nov 02, 2006
Posts: 1



(Msg. 1) Posted: Thu Nov 02, 2006 6:04 am
Post subject: Excel Macro Record Buttons
Archived from groups: microsoft>public>mac>office>excel (more info?)

In the past when I recorded Excel macros a small tool bar with buttons to
"Stop Recording" and "Relative Reference" would appear. This no longer
happens. I am using version 2002. Can anybody tell me how to get them back?

 >> Stay informed about: Excel Macro Record Buttons 
Back to top
Login to vote
little_creature

External


Since: Apr 05, 2006
Posts: 152



(Msg. 2) Posted: Thu Nov 02, 2006 4:01 pm
Post subject: Re: Excel Macro Record Buttons [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,
You are in the Mac section so I just guess. Navigate to
TOOLS>CUSTOMIZE>check STOP RECORDING. Is that what you want?


On 2.11.2006 15:04, in article
9DB9EF45-D29C-4824-A0A1-DD02EADB9B9D.DeleteThis@microsoft.com, "Spike Jones" <Spike
Jones.DeleteThis@discussions.microsoft.com> wrote:

> In the past when I recorded Excel macros a small tool bar with buttons to
> "Stop Recording" and "Relative Reference" would appear. This no longer
> happens. I am using version 2002. Can anybody tell me how to get them back?

 >> Stay informed about: Excel Macro Record Buttons 
Back to top
Login to vote
Spike Jones

External


Since: Nov 02, 2006
Posts: 1



(Msg. 3) Posted: Thu Nov 02, 2006 4:01 pm
Post subject: Re: Excel Macro Record Buttons [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

OOPS, didn't realize I was in the MAC section. Anyway, I found that by right
clicking on a blank area of the menu bar, then clicking "Customize",
"Toolbars". Then checking "Stop Recording" and closing the window, the small
toolbar appeared. After I saw that I repeated the procedure and unchecked
"Stop Recording". Now when I click "Tools", Macro", and "Record New Macro",
I get the small toolbar.

"little_creature" wrote:

> Hi,
> You are in the Mac section so I just guess. Navigate to
> TOOLS>CUSTOMIZE>check STOP RECORDING. Is that what you want?
>
>
> On 2.11.2006 15:04, in article
> 9DB9EF45-D29C-4824-A0A1-DD02EADB9B9D.DeleteThis@microsoft.com, "Spike Jones" <Spike
> Jones.DeleteThis@discussions.microsoft.com> wrote:
>
> > In the past when I recorded Excel macros a small tool bar with buttons to
> > "Stop Recording" and "Relative Reference" would appear. This no longer
> > happens. I am using version 2002. Can anybody tell me how to get them back?
>
>
 >> Stay informed about: Excel Macro Record Buttons 
Back to top
Login to vote
little_creature

External


Since: May 08, 2006
Posts: 18



(Msg. 4) Posted: Fri Nov 03, 2006 11:05 am
Post subject: Re: Excel Macro Record Buttons [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

To reset your toolbars settings
The toolbar setting is stored at file Excel#.xlb {where # stands for
some number}. The file is located in Document and setting >user
name>application data>micorsoft>excel.
1. Close excel,
2.remame the file such as test_Excel#.xlb
3. relaunch Excel and see if this helped. Because Excel will not
recognize the test_Excel#.xlb it will create another Excel#.xlb. This
will reset all your toolbars.
4. if this helped to you than you can delete the test_Excel#.xlb. If
not, or you wants your settings back then delete the Excel's newly
created one and change the test_Excel#.xlb to the original name

Spike Jones said the following on 2.11.2006 22:16:
> OOPS, didn't realize I was in the MAC section. Anyway, I found that by right
> clicking on a blank area of the menu bar, then clicking "Customize",
> "Toolbars". Then checking "Stop Recording" and closing the window, the small
> toolbar appeared. After I saw that I repeated the procedure and unchecked
> "Stop Recording". Now when I click "Tools", Macro", and "Record New Macro",
> I get the small toolbar.
>
> "little_creature" wrote:
>
>
>>Hi,
>>You are in the Mac section so I just guess. Navigate to
>>TOOLS>CUSTOMIZE>check STOP RECORDING. Is that what you want?
>>
>>
>>On 2.11.2006 15:04, in article
>>9DB9EF45-D29C-4824-A0A1-DD02EADB9B9D@microsoft.com, "Spike Jones" <Spike
>>Jones@discussions.microsoft.com> wrote:
>>
>>
>>>In the past when I recorded Excel macros a small tool bar with buttons to
>>>"Stop Recording" and "Relative Reference" would appear. This no longer
>>>happens. I am using version 2002. Can anybody tell me how to get them back?
>>
>>
 >> Stay informed about: Excel Macro Record Buttons 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]