Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Graphics Tablet Problem

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Register FAQ Community Calendar

[Excel vba] Add and remove toolbar custom buttons
Reply
 
Thread Tools
Old 25-10-2007, 09:24   #1
Ger
Inactive
 
Join Date: Feb 2007
Posts: 11
Ger is an unknown quantity at this point
[Excel vba] Add and remove toolbar custom buttons

Hi,
I have created a custom toolbar (in excel vba) with some buttons, but in the "Toolbar Options" menu
(on the toolbar) -> "Add or Remove Buttons" the voice relative to my toolbar is disabled, unlike to the others excel toolbars. I would add and remove my buttons selecting in this menu my toolbar and then check and uncheck the toolbar buttons.

Can you help me please?
Thanks in advanced
Ger
Ger is offline   Reply With Quote
Advertisement
Old 25-10-2007, 09:28   #2
TheNorm
Inactive
 
TheNorm's Avatar
 
Join Date: Jun 2006
Location: Cambridge
Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died).
Posts: 4,349
TheNorm has a nice shiny star
TheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny starTheNorm has a nice shiny star
Re: [Excel vba] Add and remove toolbar custom buttons

Have you attached the toolbar to the workbook?

Quote:
  1. Open the workbook to which you want to attach a toolbar.
  2. On the Tools menu, click Customize, and then click the Toolbars tab.
  3. Click Attach.
  4. Click the custom toolbar you want to attach, and then click Copy. Note Be sure to save the workbook after attaching a toolbar.
TheNorm is offline   Reply With Quote
Old 25-10-2007, 10:09   #3
Ger
Inactive
 
Join Date: Feb 2007
Posts: 11
Ger is an unknown quantity at this point
Re: [Excel vba] Add and remove toolbar custom buttons

Thanks but I have created a Custom Toolbar programmatically in vba.
I have an excel add-in with a toolbar. How can I programmatically attach my toolbar to the woorkbooks?
Anyhow I try on attach as you said but I can't add or remove toolbar buttons again.
Ger is offline   Reply With Quote
Reply


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

Forum Jump


All times are GMT +1. The time now is 00:00.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum