Empty Macro Problem (for a User Add-In Menu)

Altug · Mar 18th, 2002, 10:58 AM

Hi

We have an excel file that already has a custom menu build menu (like File, Edit, View etc ...) inside using some other macro that is locked. We wish to record a macro for a series of actions that involve different selections of that Custom Menu. The macro that is recorded simply is empty when recording is done. Any smart ideas to get around this ? I have tried very simple recordings just to make sure that the macro has a problem with that Custom Menu and I am 100% positive about it. It simply doesn't write anything inside the "Sub". Thanks in advance for any help.

Mark O'Brien · Mar 18th, 2002, 11:06 AM

Sounds like you're going to have to get some help writing the code "from scratch". Give us an example of what you are trying to select on this menu, including the name in the title bar and if there are any underscores in the name. For example, to do a "Save As" in Excel I would:

1. Select "File" PopUp on the "Worksheet Menu Bar" (note, the "F" has an underscore)
2. Select the "Save As..." CommandButton. (the "A" has an underscore)

Maybe some kind person will then help you.

HTH

Al Chara · Mar 18th, 2002, 11:19 AM

The following code will run the associated procedure on a custom menu:

CommandBars("CommandbarName").Controls("ControlName").Execute

The custom menu in named CommandbarName and the button is named ControlName.

Hope this helps.
Kind regards, Al.

Altug · Mar 18th, 2002, 03:27 PM

Quote:

On 2002-03-18 10:19, Al Chara wrote:
The following code will run the associated procedure on a custom menu:

CommandBars("CommandbarName").Controls("ControlName").Execute

The custom menu in named CommandbarName and the button is named ControlName.

Hope this helps.
Kind regards, Al.

Thanks I will try that and let you know about the result. Thanks again.

Altug · Mar 18th, 2002, 03:28 PM

Quote:

On 2002-03-18 10:06, Mark O'Brien wrote:
Sounds like you're going to have to get some help writing the code "from scratch". Give us an example of what you are trying to select on this menu, including the name in the title bar and if there are any underscores in the name. For example, to do a "Save As" in Excel I would:

1. Select "File" PopUp on the "Worksheet Menu Bar" (note, the "F" has an underscore)
2. Select the "Save As..." CommandButton. (the "A" has an underscore)

Maybe some kind person will then help you.

HTH

Thanks Mark,

Looks like the next approach by Al is more direct, if it doesn't work out, I will bother you guys again. Thanks so much.

Mar 18th, 2002, 11:06 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Sounds like you're going to have to get some help writing the code "from scratch". Give us an example of what you are trying to select on this menu, including the name in the title bar and if there are any underscores in the name. For example, to do a "Save As" in Excel I would: 1. Select "File" PopUp on the "Worksheet Menu Bar" (note, the "F" has an underscore) 2. Select the "Save As..." CommandButton. (the "A" has an underscore) Maybe some kind person will then help you. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 10:58 AM	#1
Altug New Member Join Date: Mar 2002 Posts: 3	Hi We have an excel file that already has a custom menu build menu (like File, Edit, View etc ...) inside using some other macro that is locked. We wish to record a macro for a series of actions that involve different selections of that Custom Menu. The macro that is recorded simply is empty when recording is done. Any smart ideas to get around this ? I have tried very simple recordings just to make sure that the macro has a problem with that Custom Menu and I am 100% positive about it. It simply doesn't write anything inside the "Sub". Thanks in advance for any help.

Mar 18th, 2002, 11:19 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	The following code will run the associated procedure on a custom menu: CommandBars("CommandbarName").Controls("ControlName").Execute The custom menu in named CommandbarName and the button is named ControlName. Hope this helps. Kind regards, Al.