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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Aug 14, 2007
Is there a way to insert a toggle button into a custom tool bar?
View 4 Replies
View Related
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
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
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