Steve Vincent wrote:Someone please help me before i go chuffing mad!
The requirement is simple. I need a custom toolbar in a presentation to allow quick and easy access to certain custom functions i have written. These are to aid non-tech savvy people to update the presentation without screwing up my cunning code that automatically updates the embedded TM1 graphs, of which there are going to be over 100 eventually.
I've been trying for 3 days now to get VBA to create a menu, and none of the examples i've found on the wacky wide wibble work. I've tried recording my steps if i build the menu manually but in true M$ style it doesn't record everything, some of what it misses being key.
All i need is a dropdown menu similar to the "File" menu. It will need to be called "RPS" and have under it about 5 links that run various macros. Please someone help with some code that will do it, because i'm frankly pi$$ed off with the lack of help with M$ products and powerpoint is the worst of the lot.
TIA (with slightly less hair than at the beginning of the week...)
I don't blame you for going chuffing mad. PowerlessPoint is my second-least favourite Microsoft product (after that brain-dead abomination Outlook), and looking at this question for you reminded me why. It's the only piece of sh... err, sorry, Freudian slip {closes PowerlessPoint}, Office that I've never written VBA code for. And now I know why.
The answer to your question will be found here:
http://www.pptfaq.com/FAQ00031.htm
BUT!!!!
You know that old Stones song "You can't always get what you want, but sometimes, you might get what you need"? I'm afraid that the answer above falls into that category.
Before concentrating on New! User! Interfaces! MS may do well to pay attention to fixing the gorram object models of some of their products, starting with Outlook, moving on to PowerlessPoint ("an event??? Wazzat?") and then cleaning up Word's.
Admittedly my first projects in Adobe Captivate taught me new ways of swearing and Captivate is, by Adobe's standards, a bugfest... but that's by
Adobe's standards, not Microsoft's. I'd still rather write 10 presentations in Captivate than one in PowerlessPoint.