I don't think so, but if the control (or rather its shape container) is
locked, then maybe you cannot press it to activate the macro. When you right
click to assign a macro, is any macro already selected for the control? It's
a Forms menu control, right?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jahanzaib" <(E-Mail Removed)> wrote in message
news:95A748E3-959C-404C-86EF-(E-Mail Removed)...
> Hi,
> Yes!
> Does it has any connection with Protect-Unprotect Sheet?
> JB
>
> "Jon Peltier" wrote:
>
>> After assigning the macro to the combobox, has the file been saved?
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "Jahanzaib" <(E-Mail Removed)> wrote in message
>> news:187888D4-F656-4E53-BCB2-(E-Mail Removed)...
>> > Thanks for Reply Mr. Peltier,
>> >
>> > I have moved code to the regular module.
>> > Problem did not fix.
>> >
>> > JB
>> >
>> >
>> > "Jon Peltier" wrote:
>> >
>> >> The combo box should be assigned to a procedure in a regular code
>> >> module,
>> >> unless you have defined a class module to capture ComboBox events, in
>> >> which
>> >> case you need to instantiate the combo box as an instance of the class
>> >> when
>> >> the workbook opens.
>> >>
>> >> - Jon
>> >> -------
>> >> Jon Peltier, Microsoft Excel MVP
>> >> Tutorials and Custom Solutions
>> >> Peltier Technical Services, Inc. - http://PeltierTech.com
>> >> _______
>> >>
>> >>
>> >> "Jahanzaib" <(E-Mail Removed)> wrote in message
>> >> news:487AA0DB-6BA8-494F-A409-(E-Mail Removed)...
>> >> > Hello,
>> >> >
>> >> > I have a combo box on my chart.
>> >> > I have writtten a (Sub) procedure in a class module.
>> >> > ComboBox calls the Sub A.
>> >> > Works Accurately, but when I reopen my file, code does not run by
>> >> > ComboBox
>> >> > and I have to re-assign Sub A to the combo box.
>> >> >
>> >> > How can I resolve this??
>> >> >
>> >> > JB
>> >>
>> >>
>> >>
>>
>>
>>
Similar Threads
