Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Stop Recording Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joanne - 26 Jan 2008 16:25 GMT
I am making a macro toolbar for efficiency sake. Problem is, in the
commands of customize toolbars, I cannot find the 'stop recording'
command to add to my toolbar.
Is there someplace else I should look for this command, or some other
way I can achieve my goal?

I am using WinXP Pro and MSOffice 2003 Pro

Thanks for the info
Joanne
FSt1 - 26 Jan 2008 17:10 GMT
hi
not sure you can find it. in the customize box,it should be in the tools
commands but it's not. reason i think is that when you click
Tools>macro>record macro....
while in record mode the menu item for record macro changes to stop recording.
when you stop recording, the menu item stop recording changes back to record
macro. there is a built in menu for stop recording but you wont not able to
add this to your custom menu. maybe have the two side by side when recording.

regards
FSt1

> I am making a macro toolbar for efficiency sake. Problem is, in the
> commands of customize toolbars, I cannot find the 'stop recording'
[quoted text clipped - 6 lines]
> Thanks for the info
> Joanne
FSt1 - 26 Jan 2008 17:24 GMT
hi
the face id is 896 or 2186 i think and not sure which. i'm researching that.

regards
FSt1

> I am making a macro toolbar for efficiency sake. Problem is, in the
> commands of customize toolbars, I cannot find the 'stop recording'
[quoted text clipped - 6 lines]
> Thanks for the info
> Joanne
Dave Peterson - 26 Jan 2008 17:40 GMT
Tools|Customize|Commands tab|Tools Category
Look for Record new macro
And add that to your toolbar.

When you're recording a macro, it'll change to the stop recording icon/function.

> I am making a macro toolbar for efficiency sake. Problem is, in the
> commands of customize toolbars, I cannot find the 'stop recording'
[quoted text clipped - 6 lines]
> Thanks for the info
> Joanne

Signature

Dave Peterson

Dave Peterson - 26 Jan 2008 17:44 GMT
The long, difficult way...

Create a new toolbar (if you haven't)
Start recording a macro so you see the stop recording toolbar.
tools|customize (just so you can see this dialog)
ctrl-click on the stop recording icon and drag it to your new toolbar.

Stop recording and discard the recorded macro.

> I am making a macro toolbar for efficiency sake. Problem is, in the
> commands of customize toolbars, I cannot find the 'stop recording'
[quoted text clipped - 6 lines]
> Thanks for the info
> Joanne

Signature

Dave Peterson

JLGWhiz - 26 Jan 2008 18:48 GMT
I guess my previous posting went into cyberspace.

Right click the menu bar> click customize> In the dialog box, click
Toolbars> Find the Stop Recording checkbox and click it.  It has its own tool
bar, not a button.

> I am making a macro toolbar for efficiency sake. Problem is, in the
> commands of customize toolbars, I cannot find the 'stop recording'
[quoted text clipped - 6 lines]
> Thanks for the info
> Joanne
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.