View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel 2007 Menus - Ron De Bruin please

Hi Jim

Until then, I create in the VS editor and copy/paste into the
Custom UI editor.


Yes this is the best way for big projects.
But for a lot of the the Excel users no option I think.(home users)

I hope the creator of the UI edito will update the program.???

Btw:
I add information on the page about creating your own templates in the UI editor.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Rech" wrote in message ...
Michael-

The custom UI editor is a great tool for several things but it is a terrible
pure XML editor. For one thing the text is constantly reformatting as you
type so the screen jumps all over the place. For another it does not
reference the customUI.XSD so you get no intellisense. For another it has
no Find or Find/Replace. For another it does not support
outlining/collapsing...

If you're going to spend any time creating or editing XML files you have to
get a true XML editor. I'm new to actually doing things with XML too, so I
don't know all the editors out there and their pros and cons. But since I
have Visual Studio 2005 I use its built-in XML editor, which supplies all
the things I mentioned above. Folks - INTELLISENSE - you must have this to
get anything done creating Ribbonx. It's great - soooo much easier.

What all XML editors lack (as far as I know) is the ability to do what the
Custom UI editor does - stick your Ribbonx file in the Excel file and create
the needed references to it. When that happens we'll have the tool we
really need. Until then, I create in the VS editor and copy/paste into the
Custom UI editor.

--
Jim
"michael.beckinsale" wrote in message
oups.com...
| Hi Bob,
|
| I tried that yesterday without success.
|
| However after you confirmed what l thought l persevered, using
| notepad, and if you change the extension to XML you can save to the
| 'Samples' folder of Custom RibbinUI tool. This means that you can make
| 'XML templates' of your favourite type of menu layouts and then easily
| edit them for the particular workbook you are developing. I used the
| examples in the tools + Ron's examples as a starting point and have
| succesfully created customised menus as l want them.
|
| You cant use the tool directly to save an 'XML template' as it will
| only save it directly into an .xlsm workbook.
|
| The next stage is to try and integrate this with John Walkenbach's /
| Rons 'MenuMaker' approach which l use on a regular basis. Any ideas?
|
| Thanks for your quick response.
|
| Regards
|
| Michael beckinsale
|
|
|
|