custom toolbar

This problem must be hard because I posted it once with no replies. I'm looking for the gurus out there to take this on as a personal challenge. :) The issue is that I am creating a custom toolbar in Excel with code but this toolbar disappears when another file is activated. This is bad...

I created a custom toolbar with the following code: Public Sub ActivateToolbar() Dim vBar() As Variant Dim iBar As Integer Dim ws As Worksheet Dim tBar As CommandBar Dim tCtrl As CommandBarControl Dim x As Integer Set ws = ThisWorkbook.Worksheets("Sheet1") vBar =...

Hello. I have a custom toolbar which is defined through VBA code. All of the buttons appear very small, with a small icon to the left and the caption to the right. I tried changing the height and ButtonStyle properties, but no dice. Is there any way to make them look like the built-in Excel...

I created a custom toolbar for my Excel application which gets created (through VBA code) when the workbook opens and deleted in the BeforeClose event of the Workbook. This is working fine. I ran into the following issue: If a user clicks close and the workbook has not been saved, he/she is...

I want to add my excel file with macro to add-ins custom toolbar. my excel file (myfile.xlsm) : GOAL/problem: In short basically,my goal is opening the "myfile.xlsm" through add-ins custom toolbar. Instead of opening myfile.xlsm directly I want it to be "hidden" in the add-ins folder. I...