Martin Reid
mwp.reid at qub.ac.uk
Wed Apr 1 13:34:45 CDT 2009
You can customise the ribbon using notepad you actually don't need a custom tool. Its just XML. To be honest I simply used Patricks add in. Made it easy and you didn't need to worry about anything else. Just install it and of you go. I just noticed this link to a sample chapter on Excel http://www.oaltd.co.uk/Spreads/Excel2007VBAProgRef_ch14.pdf Martin Martin WP Reid Information Services Queen's University Riddel Hall 185 Stranmillis Road Belfast BT9 5EE Tel : 02890974465 Email : mwp.reid at qub.ac.uk ________________________________________ From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins [ssharkins at gmail.com] Sent: 01 April 2009 19:19 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Getting error of Ribbon argument Thanks Martin and Max -- I feel like I'm in Bizarro World. :( You shouldn't need a custom interface tool (Custom UI Editor) -- it should be just as simple in Word and Excel as it is in Access. I did find a message from awhile back -- from David McAfee where he seems to accomplish what I originally tried (using ShowToolbar). Now, the original request was about doing this in Excel, but David doesn't say whether he tested it in Access or Excel. If someone got this to work in Excel, please share with me what event you used. Thanks! Susan H. ----- Original Message ----- From: "David McAfee" <davidmcafee at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, December 03, 2008 6:35 PM Subject: Re: [AccessD] Turn off the ribbons programmatically > Well, that works for me: > > IF SysCmd(acSysCmdAccessVer) = 12 THEN DoCmd.ShowToolbar "Ribbon", > acToolbarNo > > I also put a command button on a test form to turn it back on. > Susan H. >I have seen VBA solutions but XML is the general approach taken to work >with the Ribbon, Its usually a joint approach VBA and RibbonX. See > > http://www.rondebruin.nl/ribbon.htm > > http://www.xtremevbtalk.com/showthread.php?t=265636 > > http://msdn.microsoft.com/en-us/library/bb421511.aspx > > Or better yet get this > > http://pschmid.net/office2007/ribboncustomizer/index.php > > I worked on the development of this with Patrick. Gets the job done. The > site also contains tons of info on RibbonX -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com