LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Accessing personal macro's all the time

Wow, I'm going to have to get used to some responses not showing up on
the board for a while. I didn't know there were a bunch of responses
that hadn't appeared yet before I made my last post. Anyway, I don't
think my question was really answered. Lastnight I went thru my Excel
book and I think I found my answer....

When I tried to add a button to my toolbar, there were only the
"Custom Menu Item" & "Custom Button" option unders Macros, and
that button option has a silly smiley face, so I didn't want to use
that. I didn't know that all I had to do was use that smiley face,
then change the image and assign my macro to the button. So it's
like this, broken down:

1. Right-click on toolbar and select the Customize option
2. Select teh Commands tab
3. Select the Macros category
4. Drag a Custom Button to the toolbar
5. Right click on new Custom Button and select Change Button Image
option and then select a new icon
6. Right click on new Custon Button and select Assign Macro... and
select the macro to assign to the button

Too bad this info was way back around chapter 20 of my book. I like
the book, but dammit, I want to be able to use the stuff I'm making
during the first 20 chapters too.

Thanks all for your input!

Eugene

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel macro's to run at a scheduled time Pramod Kamath Excel Discussion (Misc queries) 1 August 15th 06 02:04 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Accessing personal macro's all the time leaftye - ExcelForums.com Excel Programming 11 July 2nd 05 04:04 PM
Why do i have to re-assign macro's all the time Simon Lloyd[_492_] Excel Programming 4 June 22nd 04 07:19 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"