Replies

Thank you David,

Restarting numbering has bugged me for years and I’m fairly experienced with Word in its many versions. I use styles that have been created from scratch and have numbering attached. However in my documents I need to restart numbering after headings – but it could be after a Heading 1, 2, 3 or 4! I wish I’d known about that code years ago.

Regards
Karen

More than likely on a second parameter passed into the function.

Thank you Andrew. That works beautifully for the watermarks. Is there anyway I select whether it goes into a header or footer (or just at the insertion point). This is because we use the building blocks for other things as well – some go into footers, and some just in the document in the insertion point?

I could copy the function and create one for each of the options, but I just wonder how I would go about making it generic for all insertions of autotext.

This has been helpful, thank you. (Now I need to change my settings so I get an email when I get a reply :rolleyes:)

Thank you sooooo much. You won’t believe how frustrating an extra space can be :rolleyes:

Thank you so much. There was a string variable named Replace. Once I changed this to strReplace everything worked perfectly! Pity the error message didn’t just say I had an ambiguous name or something understandable (to me anyway :o).

If the inline shape is selected, you should be able to do something like this:

Selection.InlineShapes(1).Height = Application.InchesToPoints(2.5)

Thanks Hans, I had to add Selection.MoveLeft Unit:=wdCharacter, count:=1, Extend:=wdExtend to select the shape and then the code worked beautifully.

Hello Don,
I have attached a zip file which contains two Excel files which each have code copied from the MSDN website, and which I can’t work out how to get to work. The examples on MSDN say we can create these as customized documents, but then go on to talk about Visual Studio 2005 which is what I believe this code is aimed at. I haven’t been able to find Visual Basic examples which actually work, which is why I thought that perhaps this code was not for VBA. I have no experience, nor do I own the product, of Visual Basic (.net or otherwise) or Visual Studio. I solely work in VBA.

Any help would be appreciated, thanks.

Hello Andrew,
I have attached a zip file which contains the Word document that I am trying to work with. This will eventually be a template loaded into the Startup folder. It contains a description of what I am trying to achieve and why, along with pictures of the toolbars I am trying to replace with groups, and the XML code that makes up the customised tab, groups and buttons.

Any help would be appreciated.

Also, do you know with what program I can create my own images for buttons? Specifically png formats?

Thanks.

I started off really excited, I found a good book (RibbonX, customizing the Office 2007 Ribbon by Robert Martin, Ken Puls, and Teresa Hennig), through this found a little program called the Office 2007 Custom UI editor which saves trying to deal with xml in zip files (which I really couldn’t get my head around – too many steps – and for some reason my laptop doesn’t open zip files unless I use Winzip), and managed to create new tabs, and groups with simple buttons in the ribbon with call backs to VBA. However, now I’m trying to create a tab that contains a checkbox that should select which groups on this tab are displayed. The interface looks fine, but I can’t get it to do anything! All of these articles on MSDN use examples of VB, Visual Studio or C# code, and I don’t have the knowledge to rewrite that in VBA. Everything I have read so far leads me to believe that VBA should be able to handle this, but as I can’t convert any of the examples to VBA I’m pretty stuck.

Everything I’ve learnt about VBA has been self taught with help from forums such as this lounge and plenty of books, but the scarcity of information, even from Microsoft, is making me very frustrated. Perhaps I’m looking in the wrong place? Can anyone tell me where else to go to find help?

Thanks Jeff. Your second reply to my post (which for some reason I can’t see online) that VBA arrays are zero-based lead me to look again at arrays and in particular “base”. I had an Option Base 1 setting (probably left over from when I used this form slightly differently for another project) and once this was removed everything worked. Now I just have to check that removing it didn’t break something else!

Thank you. I had just found that, and now have to try and work out why I had it there in the first place! It was possibly just a legacy as part of this form was used on another project.

Thank you Hans. This works perfectly with the sample form, but when I put into my actual form, which is a multipage form, I get a subscript out of range error. Firstly I thought it was because I was initially populating the listbox with items from a text file, but even when I used a simple additem to populate the listbox, I get the error when I try to sort the list. I’ve attached the actual form here if you can tell me why there is a difference.

I’m still looking at the posts that Jeff recommended and trying to make sense out of them.

Thanks for your prompt reply Hans. I’ve just had a frustrating day playing around with this, and your code works beautifully.

Earlier versions of Word showed the line number and measurement in centimetres from the top of the page, and the column number from the left margin, in the status line at the bottom of the screen. Is there anyway to show this in Word 2007?

Found it – I usually have sooo much trouble finding anything on the Microsoft site, but this surprised me.

It is actually quite simple to customise the status line – simply right mouse click on the status line to see a list of options. Select the ones you want to appear and hey presto