Nick Hodge's Excel Blog - All Comments

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

roryfynn — Tue, 01 Jul 2008 08:13:37 GMT

Nick... That is perfect. Thank you.

I had found another workaround using group policy and your remove ribbon macro. Group policy was essential to prevent keyboard shortcuts too.

Thanks again.

Best regards,

Rory

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

Nick Hodge — Mon, 30 Jun 2008 22:01:00 GMT

Rory

I don't think it can be hidden, but it can be disabled...any good?

</commands>

</ribbon>

</customUI>

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

roryfynn — Mon, 30 Jun 2008 14:44:08 GMT

Hi Nick,

Firstly thanks for this series of great articles; much appreciated.

I've got an interesting application for customisation... securing a remote/citrix instance. I need to allow the user to view the spreadsheet in all it's glory ie formulae and data but there is absolutely no need for anything else.

So I've started from scratch and then disabled the remaining buttons in the office menu. However... the last thing I need to do before achieving mission accomplished status is to get rid of or to disable the "excel options" button.

Do you know how I can achieve this in the customUI XML or in macros? I tried to look for a reference to the button but haven't been successful.

Any immediate help would be greatly appreciated as this is time-critical my end.

Thanks so much

Regards,

Rory

vba insert rows columns

vba insert rows columns — Mon, 23 Jun 2008 13:29:16 GMT

Pingback from vba insert rows columns

open xlsx files in excel 2000

open xlsx files in excel 2000 — Sat, 31 May 2008 10:55:00 GMT

Pingback from open xlsx files in excel 2000

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

Nick Hodge — Sun, 04 May 2008 09:51:58 GMT

Who's Tim?

Excel internally knows when it is in edit mode and I know no way of replicating that using ribbonX.

I don't know if that is simply a ribbon issue. I have never known a way in VBA of ascertaining if excel is in 'edit' mode.

Sorry

Nick

re: Summit in Seattle

xcelion — Thu, 01 May 2008 10:12:26 GMT

Looking forward for pictures of excel gurus at Summit :)

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

Franc — Mon, 28 Apr 2008 23:25:32 GMT

Hi Tim, I hope you can help.

I noticed that when I type in a worksheet most of the buttons on the ribbon get disabled(grayed out), once I move out of the cell I'm typing in, the disabled buttons get enabled again. I want to do that to my custom ribbon. What code do I need to use? How can I tell my custom ribbon to disable buttons when I type?

I've searched on the internet but haven't found the answer.

Franc

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

Agus Surachman — Wed, 23 Apr 2008 00:06:02 GMT

Nice.

I'm waiting for the last part eagerly. :)

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

Nick Hodge — Tue, 22 Apr 2008 12:46:16 GMT

Agus

It is sort of possible to do stuff with ribbon controls on the fly. I will need to get around to writing the last bit.

The theory is this:

You use an onLoad attribute in you customUI declaration like so

<customUI xmlns="schemas.microsoft.com/.../customui"

onLoad="myRibbon_onLoad">

You will notice when generating the callback for this it will pass you a ribbon object. In this callback, in a standard VBA module, capture this ribbon object and assign it to a global variable (outside and above any procedures in the module). e.g

Public myRibbon As IRibbonUI

Sub myRibbon_onLoad(ribbon As IRibbonUI)

Set myRibbon = ribbon

End Sub

Now you have the ribbon captured and can use it's Invalidate property to force a rebuild (You can rebuild an inividual control using it's InvalidateControl property also and pass in a controlID)

So, for example, you may trigger the Invalidate from a button_click() event on a ribbon control and then use any of the 'get' attributes (getImage, getLabel, etc) to rebuild other controls.

That is probably as clear as mud, so I will try and get around to the last part this weekend. I may even put some videos together :-)

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

Agus Surachman — Tue, 22 Apr 2008 10:57:08 GMT

Nick.

Is that possible to change the content of Ribbon on-the-fly (dynamically)?

For example the menu button can be added or deleted conditionally, and also other properties such as the picture.

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

Agus Surachman — Tue, 22 Apr 2008 00:40:22 GMT

Thank you Nick.

Fantastic

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

Nick Hodge — Mon, 21 Apr 2008 12:44:39 GMT

Agus

This would be a splitButton and addressed like so

</menu>

</splitButton>

re: Questions on customising the ribbon

pk — Mon, 21 Apr 2008 12:32:25 GMT

So the way to make code available to all workbooks is through an add-in (xlam), Nick, can you do a page on how to create, implement, and distribute an xlam?

Thanks so much for all the time you've put into this it has been immensely helpful.

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

Agus Surachman — Mon, 21 Apr 2008 00:43:36 GMT

Nick.

I'm wondering how to create button which has stype like Macro button or Paste button?

It appears as one button but when we hover it, it apprears two seperate button.

Please your help.