Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with german excel version
You might use the ID property:
set cb = commandbars.FindControl( id:=30010,Visible:=True) ? cb.parent.name Worksheet Menu Bar ? cb.caption &Help This gets the Help control. the help control is also a commandbar itself. http://support.microsoft.com/default...b;en-us;215149 OFF2000: CommandBar Indexes Different from Office 97 http://support.microsoft.com/default...b;en-us;213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default...b;en-us;159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default...b;en-us;213211 XL2000: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default...b;en-us;162814 XL97: Sample Macros to Return ID for a CommandBar Control -- Regards, Tom Ogilvy "Peter" wrote in message ... In a VBA application for an english excel version, I have the following line: iHelpLocation = cbr.Controls(“Help”).index I have to run the application with a german excel version and then this line causes trouble. I tried to replace it by iHelpLocation = cbr.Controls(“Hilfe”).index but this doesn’t work. How do I have to change this line to run the application with a germen excel version ? Thank’s for your help !! Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS excel currency conversion from UK to German | Excel Worksheet Functions | |||
Error opening in German Excel | Excel Discussion (Misc queries) | |||
German Excel Menu equivalents | Excel Discussion (Misc queries) | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Problems with german excel version | Excel Programming |