Nick Hodge's Excel Blog - All Comments

?????????????? ???? 8 ?????????? » ?????????????????? ???????????? «100$ ?????????????? ????????????

Fri, 26 Feb 2010 20:46:54 GMT

Pingback from ?????????????? ???? 8 ?????????? » ?????????????????? ???????????? «100$ ?????????????? ????????????

Excel Theatre Blog » Excel Twitters 20090403

Excel Theatre Blog » Excel Twitters 20090403 — Tue, 08 Sep 2009 01:30:00 GMT

Pingback from Excel Theatre Blog » Excel Twitters 20090403

re: Ribbon, Step-by-Step. Part 2 (Begin Customisation)

djessellis — Thu, 27 Aug 2009 14:23:17 GMT

Hi Nick - with regards to the re-purposing of the three 'key' officeMenu options.

How can this be done, and also - how do you disable?

Thanks!

Jesse

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

Nick Hodge — Wed, 17 Jun 2009 05:47:38 GMT

Sure

As explained using a controls idMso brings it in with it's built-in functionality.

If you want this available everytime you open Excel, put the RibbonX in your personal.xlsm file or in a workbook in your xlStart folder

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

barkey147 — Tue, 16 Jun 2009 14:49:46 GMT

and when i open exsisting excel files, i have no Custom UI. how can i get the cutsom UI buttons just to always be there no matter what? Is that possible?

thanks for the help

Travis

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

barkey147 — Tue, 16 Jun 2009 13:59:08 GMT

Thanks Nick!

I also figured out i could simplify it like this

<tabs>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

Now is there a way that i can have this "shortcut" button show up automatically when i open a new blank document? In other words Is there a way to modify the default blank template?

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

Nick Hodge — Mon, 15 Jun 2009 21:58:13 GMT

Travis

You RibbonX needs a little correction and the code below that will draw and arrow similar to the default one on the active worksheet. Place the VBA code in a standard module in a macro-enabled file (xlsm)

RibbonX code

<tabs>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

VBA Code

Sub drawArrow(control As IRibbonControl)

Dim wks As Worksheet

Set wks = ActiveSheet

With wks.Shapes.AddLine(100, 100, 150, 200).Line

.EndArrowheadStyle = msoArrowheadOpen

End With

End Sub

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

barkey147 — Mon, 15 Jun 2009 18:30:52 GMT

Nick,

Thanks for the great tutorial! I'm not an expert by any means but this was very easy to understand. I was able to use these guides to add a button to the "Home" tab for simply inserting an arrow (ShapeStraightConnectorArrow). The button appears fine in the Ribbon, but i don't know how to assign it the correct excel function of inserting the ShapeStraightConnectorArrow. What is the coding for the module to make the button function like that?Or is it simply possible to assign onAction="ShapeStraightConnectorArrow"

Here's my code for the ribbon button.

<tabs>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

Do i need the module? how would it work?

Sub Arrow(control As IRibbonControl)

If control.ID = "Button1" Then

'What goes here?????'

Else 'Do i need this????'

End If

End Sub

Thanks,

Travis

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

Nick Hodge — Fri, 08 May 2009 07:28:10 GMT

Gabe

No that is not currently possible as i understand it, the first add-in loaded loads all the ribbon customisations

re: Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

gabethegrape — Fri, 08 May 2009 04:48:46 GMT

Nick,

Is it possible to have one add-in create the custom ribbon item and a second add-in to appear as an item in that ribbon?

Cheers,

Gabe

Contextures Blog » UK Excel User Group Conference April 2009

Contextures Blog » UK Excel User Group Conference April 2009 — Tue, 07 Apr 2009 04:04:32 GMT

Pingback from Contextures Blog » UK Excel User Group Conference April 2009

Contextures Blog » Excel Twitters 20090403

Contextures Blog » Excel Twitters 20090403 — Fri, 03 Apr 2009 04:04:24 GMT

Pingback from Contextures Blog » Excel Twitters 20090403

The Hodge Blog | On This Day…

The Hodge Blog | On This Day… — Wed, 25 Mar 2009 07:09:03 GMT

Pingback from The Hodge Blog | On This Day…

re: Ribbon, Step-by-Step. Part 3 (The Office Menu and Re-purposing)

djessellis — Mon, 23 Mar 2009 10:08:55 GMT

Wow - thanks for that... I think this is great stuff... Really allows developers to take out the risk of models being mucked around with!

Thanks you so much.

re: Ribbon, Step-by-Step. Part 3 (The Office Menu and Re-purposing)

Nick Hodge — Sun, 22 Mar 2009 08:53:35 GMT

Jesse

The startFromScratch="True" will take away everything except New, Open and Save. Of course, if it is a new workbook you will get Save as, by pressing Save. However, to put it back in you just roll a custom button and write your own VBA code to Save As. The RibbonX looks like this

</officeMenu>

</ribbon>

</customUI>

and the VBA code, (IN A STANDARD MODULE), looks like this. (There is no error code here to decide if dialog was cancelled and nothing to default to say xlsx, but all that can be done very easily)

'Callback for btnSaveAs onAction

Sub mySaveAs(control As IRibbonControl)

Dim strFName As String

strFName = Application.GetSaveAsFilename

ThisWorkbook.SaveAs Filename:=strFName

End Sub