View Single Post
 
Old 04-21-2017, 04:55 PM
NevilleT NevilleT is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Mar 2015
Posts: 29
NevilleT is on a distinguished road
Default

Hi Charles. Thanks for responding. Not clear on the answer. Let me explain again.

I look at Style Manager by opening the customise ribbon and looking at all commands. I go down and hovering over the menu item, it tells me it is a macro.

At this point, I am not sure what I do with it. Since it tells me it is btnNewStyleSets_Click, do I have to add that as a sub to my VBA and write some code for it to open the Style Manager panel?

Apologies for asking such basic questions but I have spent a considerable time on Google without success. I did look at your example, but it seems to be a straight forward macro you wrote yourself, and I see how that works. I have a few VBA routines I have written on the toolbar, but cannot work out what I do with an inbuilt macro.

I think I have my head around commands, and running my own VBA routines, but not sure what to do with inbuilt Macros. Also thanks for the book reference.
Reply With Quote