Custom Floating Toolbar Created - Icon And Size Questions Remain

Oct 16, 2008

I have created a custom floating toolbar that works perfect (thanks to all the reading on here!). My workbook is a stand alone estimating tool that many users will have a copy of.

I have two things I want to do yet but I cant find it on here.

1) My buttons on my toolbar - I want to have custom icons. I can do this temporarily but when I exit my worksheet and re-open they are lost. Is there anyway to save a custom icon. I am willing to add it to the icon list if necessary and then when users open the workbook copy the custom icons onto their computer. But I am not sure how/where I could do this.

Worse case, can I color my button text?

2) When my toolbar appears, it is wide, all buttons are going left to right. I want the size to be small width so the toolbar buttons are on top of each other. Any thoughts? I tried adding a .width but it didnt work.

View 9 Replies


ADVERTISEMENT

Add Icon To Custom Toolbar Menu

Mar 4, 2008

how to manage a custom faceid. Though, I am not too sure as to how to assign an actual icon to a custom toolbar. I can try the pasteface method; though as the source file is a .png; the picture might be too small.

View 2 Replies View Related

Increase Size Of Image In Button (msocontrolbutton) Of Custom Toolbar

Aug 12, 2006

Image size appears in button(msocontrolbutton) of custom toolbar Excel 2000 is very small and blurred using below code. How I can increase size of image in button (msocontrolbutton) as well as brightness of image in custom toolbar? I am able to increase size of button using width and height property but image appears in center of button as 16X16. How to fit image to button(msocontrolbutton)?

Const cImgCommandBarID As String = "TMC Img Toolbar"
'Image code
Dim cbImgBar As CommandBar

Set cbImgBar = CommandBars.Add( Name:=cImgCommandBarID, Position:=msoBarTop)

'cbImgBar.context = 1000
Dim cbImage As CommandBarControl
Dim imgTool As Shape
Dim sFileName, ImgSheet
sFileName = ActiveWorkbook.Path & "ImagesABC.jpg".....................

View 2 Replies View Related

Email Icon In Spreadsheet As Per Email Icon In Quick Access Toolbar

Aug 20, 2014

I need to send out an order form (spreadsheet) to 100's of people that need to complete the form and email back to me as an attachment. If I was completing the order form myself I would use the "email" icon that I have pinned to my Quick Access Toolbar (QAT). However, most of the recipients don't even know the Toolbar exists.

Is there a way I can insert an icon / hyperlink in the spreadsheet that does the same thing as the QAT icon. I can insert text to say "click here to email your order" (or similar).

I need to keep it in an excel format and an icon is so much better that asking them to save to their hard-drive and attach to an email, etc.

The QAT icon is exactly what is needed but I need to provide a spreadsheet that works for folk who haven't got the icon.

View 4 Replies View Related

Create Floating Toolbar (not Menu)

Jan 13, 2007

Need to code to create a custom floating menu which appears on opening the workbook. It works brilliantly, but I'd like to adapt it so that I can create a floating toolbar, which is fully expanded upon opening, where the button faces are plain text which I designate. Let's suppose the macros I want the buttons to trigger are called MacroA and MacroB, and that the text on the buttons should read "Do A" and "Do B".

Sub Create_Menu()
Dim MyBar As CommandBar
Dim MyPopup As CommandBarPopup
Dim MyButton As CommandBarButton
Delete_Menu 'make sure commandbar isn't already running
Set MyBar = CommandBars.Add( Name:="My Menu", _
Position:=msoBarFloating, temporary:=True)
With MyBar
.Top = 175
.Left = 850
Set MyPopup = .Controls.Add(Type:=msoControlPopup)
With MyPopup
.Caption = "My Tools" 'change to suit....................

View 6 Replies View Related

Floating Toolbar As Default In Pivot Chart

Jun 28, 2007

I've created a Pivot Chart in which I want to display travel by various folks to mulitple sites. The Site field is a Page field. If I set the Pivot Chart to a Custom -- Floating Bar style it displays fine, but if I change the Page field selection the chart reverts back to a stacked bar style.

I've tried setting the default chart type to Floating Bar (this doesn't take), and naming a custom style that is Floating Bar (and setting the pivot chart to this custom style -- but again the style does not hold on a change to the Page field).

I ran into this a few years ago and wrote some event macros to reformat the chart when the sheet is activated and when it calculates, but it seems there should be a simpler (built-in) way. Am I missing something obvious? Is there a way to make the Floating Bar style stick in a pivot chart without resorting to VBA updating?

View 9 Replies View Related

User Programable Icon On Toolbar

Mar 24, 2009

I have an application macro which displays a Userform which lists and lets me select/load my favorite XL WBs. It also lets me add and/or delete favorites.

At present, I have to activate it with a Ctrl+Key combination.

Is there anyway I can assign it to an icon on the toolbar.

View 9 Replies View Related

Excel 2010 :: Can't Find The Pivot Table Icon In The Toolbar

Mar 31, 2012

I can't find the Pivot Table icon in the toolbar. I tried "Insert", I can only see the 'table' icon, but cannot see the 'pivot table' icon. how can I find this 'pivot table' icon, or create it in the tool bar?

View 4 Replies View Related

Custom Transferable Toolbar Of Custom Functions

Sep 2, 2008

I want to be able to create a range of VBA userforms to quickly perform long tedious tasks. I want these userforms to be accessed from a nice tidy toolbar.

I have done this and it looks nice and works well. What I would like to be able to do is have my custom toolbar of userform controlled functions be transferable so that if someone else wants my toolbar and attached functions they can install it easily much the same way you can do with an add in.

Is this sort of thing possible or does it require them to manually install all my userforms, modules and toolbar? If it is possible what sort of things should I be looking at?

View 9 Replies View Related

Created A Toolbar With Buttons That Run Macros

Oct 14, 2008

I have created a toolbar with buttons that run macros. When the macro is assigned to that button the macro will run fine. However, when the file name of the excel workbook has changed (file relocated or name changed) then the macro (button in the toolbar) does not work and has to re-assigned in the toolbar. Is there anyway of getting around the problem of having to reassign the macro to the toolbar button whenever the file name/directory changes.

View 5 Replies View Related

Userform In Taskbar With Custom Icon?

Apr 15, 2012

I was wondering if this code is supposed to make the icon on the taskbar change to the custom icon as well?

If not, what would need to be added or changed to make it so?

It changes the Userform Icon without issue and adds the userform to the taskbar, but it is not updating the icon on the taskbar.

View 2 Replies View Related

Assign Code To Toolbar Created In VB To Hide Sheets And Then Rehide

Jan 22, 2009

I have code which creates a tool bar which works Ok, however I can't get the statement correct to assign code to it.

View 8 Replies View Related

Excel 2007 :: Custom Icon Sets For Conditional Formatting?

Mar 26, 2010

Any way to import and use icon sets for conditional formatting other than the ones provided in excel 2007? I would like to have some circles and shapes in colors other than just yellow, green, red, and gray.

View 5 Replies View Related

Custom Toolbar Buttons

Jul 28, 2006

I have created 2 toolbar buttons which were attached to a macro that ran the original 'EditTenancy'. I now want to change these to use anew macro 'EditExistingTenancy' but cannot see how to do it as when I right click now I only get a toolbar list.

Do I have to creat 2 new toolbar buttons?

How do I get rid of the non-functioning ones?

View 4 Replies View Related

Custom Toolbar Creation

Jan 11, 2007

I'm preparing a model which has a few macros built-in. Let's call them Macro A, B, C etc. I want to trigger them via buttons on a custom toolbar (no problem) which a recipient of the model, on another PC, will be able to see (problem).

It was suggested to me that in Customize mode I can right click the custom toolbar and then click "Attach..." but this always causes Excel (2002) to freeze; I must then close Excel.

Someone else suggested that a better way is to have VBA code create the toolbar "on the fly" automatically when a recipient opens the spreadsheet. This is too advanced for me to write at the moment. Could someone give me a steer?

View 9 Replies View Related

Disable Custom Toolbar On Any PC

Sep 25, 2007

I created a custom toolbar called "PAT" for users. It has 5 custom buttons-save, import,submit,close,help. I attached it to the toolbars as instructed at the site http://www.ozgrid.com/VBA/toolbar-remove-restore.htm. I need to keep the worksheet tabs showing so I cannot use the application.DisplayFullScreen = True. For each worksheet that the user will be viewing, i have the following


Private Sub Worksheet_Activate()
Application.CommandBars("PAT").Enabled = True
Application.CommandBars("PAT").Controls("Import").Enabled = False
Application.CommandBars("PAT").Controls("Submit").Enabled = False
Application.CommandBars("PAT").Controls("Save").Enabled = True
Application.CommandBars("PAT").Controls("Help").Enabled = True
Application.CommandBars("PAT").Controls("Close").Enabled = True
End Sub

ON my workbook activate code and workbook open code, I remove all native toolbars so only the one i created is showing, using Application.CommandBars("PAT").Enabled = True
On workbook deactivate I have the following.................

View 4 Replies View Related

Tie Custom Toolbar To Workbook

Feb 8, 2008

I have created a macro and would like to use it in other workbooks. Can this be saved to the tool bar for this purpose?

View 2 Replies View Related

Protect Custom Toolbar

Mar 31, 2008

I have written VBA to create and populate a custom toolbar when a worksheet is opened, and to close when it is closed. I need to know if its possible to disable the close button of the toolbar, as I don't want any of my work colleagues accidentally closing the toolbar and then coming to me to ask me how to reopen it.

View 4 Replies View Related

Custom Toolbar .xlb File

Apr 6, 2008

I am tring to find the xlb file, but it does show in my laptop. I open and close the xl App, but still could not find it

View 3 Replies View Related

Saving Custom Toolbar With File

Oct 7, 2008

The file who containd the toolbars informations is C:Documents and Settings<<USER>>Application DataMicrosoftExcelExcel.xlb

I copied this file to another computer and my custom toolbar appeared there.

In a file, I created a custom toolbar with submenus. It is possible to save this toolbar with file, so that I can use the file on other computers without the need to create each time this bar.

View 2 Replies View Related

Attaching A Custom Toolbar To Workbook

Apr 14, 2009

I have created a workbook and made a custom toolbar to perform the macro functions for the sheets in the workbook. Everything works great for me, but I want to attach the custom toolbar to the workbook so that whenever someone else pulls up the workbook they pull up the custom toolbar too.

I used the tools menu, clicked customize, toolbars, attach, selected the custom toolbar and clicked copy.

No toolbar appears.

I can select View, Toolbars, and select the custom toolbar, then the toolbar appears, but when I close the sheet the toolbar remains.

When someone else opens the sheet, the toolbar appears without any "buttons." It is an empty toolbar.

The help text isn't helping because the instructions for attaching a custom toolbar to a worksheet (tools/customize/toolbars/attach/copy) do not attach the toolbar to the workbook.

View 6 Replies View Related

Can't Run Macros Off A Custom Toolbar Anymore

Oct 6, 2009

A couple years ago i made a giant spreadsheet and had 2 custom toolbars to run macros from to manipulate the sheet.

This year i re-did the sheet, meaning all my old data was replaced (it's a giant schedule basically).

However, the Macros in the custom toolbars stayed exactly the same and performed the same function and are directed to the exact same cells, rows, columns, etc..

But now when i hit the buttons on the custom toolbars to run my macros, i get the following message... all the time...

**
A document with the name "NHLsheet.xls" is already open. You cannot open two documents
with the same name, even if the documents are in different folders.
To open the second document, either close the document that's currently open, or rename one of the documents.
**

Trouble is, i have only 1 document open!
There's something in the macros that thinks i'm trying to open a new document but i'm clueless as to where or why.. they are very simple macros
that do not require the opening of any new workbooks..

All they do is point to another sheet within my open workbook, "NHLsheet", copy a particular row from that sheet, and paste it to a specific spot onto another sheet within my workbook, "NHLsheet".

Here is a sample:

View 14 Replies View Related

Launch Form From Custom Toolbar?

Oct 3, 2012

I have a custom toolbar with a button on it that I want to open a userform from.

I have tried this macro

VB:

Code:
Sub Admin_Show()
frmAdmin.Show
End Sub

[Code]....

View 3 Replies View Related

Creating Custom Dropdown In Toolbar

Jun 6, 2007

I work with excel docs that have alot of sheets. I managed to create a vba form that has a listbox populated with the sheet names, that when clicked goes to the respective sheet. The problem is that when the form is open i cannot focus on the excel sheet - the form needs to be closed first.

1 ) Is it possible to make an excel vba form dockable (so it could be displayed on the right where help would be)

Or

2) Would it be possible to create a drop down in the toolbar that would have the sheet names.

I think the latter is a cleaner solution (if possible).

View 9 Replies View Related

Delete Custom Menu Bar / Toolbar

Oct 26, 2006

I was making a custom Menu Bar in excel. In order to troubleshoot I executed the code a no. of times, resulting in multiple but same menu bars in excel application. Now the problem is that even if I quit excel, the menu bars dont seem to go..How do I get rid of them.

View 2 Replies View Related

Tooltips To Custom Toolbar On Mouse Over

Nov 8, 2006

I am having trouble assigning a tooltip to a button on a custom toolbar. I have found an example in the forum, but it dont seem to work for me.

Sub Toolbartext()
With Toolbars("Field Tracking Tools")
.ToolbarButtons(1). Name = "Displays Field Officer Data Entry Form"
End With
End Sub

View 2 Replies View Related

Custom Toolbar Toggle Button

Aug 14, 2007

Is there a way to insert a toggle button into a custom tool bar?

View 4 Replies View Related

Add Custom Menu Item / Toolbar

Apr 12, 2008

Trying to write a VBA code to add a new menu item with submenus on the Standard toolbar when Workbook_Open and then deleting it (_Before close). Just having trouble with the creating of the menu item. Here is what I have so far:

Sub Workbook_Open()
...
Dim menuitem As CommandBarPopup
Set Menu = Application.CommandBars("Menu Item").Controls.Add (Type:=msoControlPopup, Before:=13)
...
End Sub

View 2 Replies View Related

Custom Toolbar/Commandbar For Template

May 17, 2008

How can I save a new xlt or xls so that the toolbar settings I am viewing will always reload with excel. I have tried purging all items from my xlstart locations, but unwanted (and unchecked) toolbars keep reappearing when I restart excel.

View 4 Replies View Related

Save Workbook With Custom Toolbar/CommandBar

Jun 2, 2006

I had made a Workbook with my own command Bars, and everthing is ok .. the problem is when i copy it to anthor pc. i have got an error msg. and when i check the code (debug) i've found the problem is with that command bars ( it's missing )
and now the Q is:

how to copy a workbook with it's all add-in's and customised bars ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved