Hi,
I have migrated the Excel 2003 templates to Excel 2007 with Ribbon Customization. For that I used Office 2007 Custom UI Editor tool. Also used VBA.
The basic functionality of Paste is not working in New Excel 2007 templates.
I am getting Argument Not Optional error. So i wanted to disable Ctrl+v which is also not happening.
Please help.
Pri
Last edited by VBA Noob; 11-11-2008 at 09:29 AM.
If your ribbon xml is using the onaction parameter to specify a macro to be run you will need to update the routine header of the routine to contain variable object of IRibbon type.
The CustomUI tool has a button for generating the Callbacks required for your onaction routines.
There is no such code written in VBA for Ctrl+v as it is the basic functionality of Excel because Ctrl+c is working fine w/o code.
The same copy-paste is working fine macro enabled excel 2003 templates.
I am not able trap the error also.
Pri
Does the template that errors contain vba macro(s)?
Have you changed the routine signature to work from xml definition?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks