How To View Hidden Macros

[coachj]

I'm attempting to debug a spreadsheet fm an unknown developer. On the spreadsheet are a number of dropdown objects. I right-click on one of the dropdown objects go to Assign Maco... option and see a macro name such as DropDown4_Change assigned to this object. I don't see the code for this macro anywhere in the spreadsheet. I go to vba and there's no corresponding sub or module for this macro that I can see. The macro works without error. It assigns a range of values (which I also can't find) to display in the dropdown and based on what's selected the linked cell's color gets set or changed. I need to add or modify the options in each dropdown box. Where is the macro or the module or the worksheet that performs this operation?

Thanks

 

[combo]

The first candidate is sheet's module. To open it:
- right-click sheet's tab and select view code, or
- in the design mode right-click drop-down and select view code, or
- in the VB editor, project explorer, double-click the sheet in Microsoft Excel objects.

 

[RobBroekhuis]

The macros are most likely contained on the code pages for the worksheet objects. In the VBE project browser, double-click on the worksheet object that contains your combobox. Or, using the control toolbox toolbar, enter design mode (top left icon on the toolbar) and double-click on your combobox.
Rob

 

[Nikita6003]

Try this:
RightClick the dropdown , choose Assign Maco from the popup menu & click EDIT - this shld take you straight to the DropDown's code...


HTH

Cheers
Nikki

 

[Nikita6003]

and if your DropDown's a FORMS combobox, the code should be on a separate module sheet (named Module1 or something like that - unless the unknown developer's been naming his/her module)
If it's an Active-X control, the code for the OnClick is stored on the WorkSheet module where your Combobox resides

Cheers
Nikki

 

[coachj]

Thanks for the replies one and all alas still cannot find the code associated with this macro/module/worksheet. I tried every suggestion and still no go. Could I possible send/email this spreadsheet to someone willing to take a stab at finding this code.

Thanks

 

[Nikita6003]

You'll get loads of email addresses - but here's mine for a start ;-)

Nikita6003@hotmail.com

Cheers
Nikki

 

[combo]

Surely Nikki will find the code, so for my interest only:
mkb@op.pl

 

[RobBroekhuis]

Hey, you two - please report back here what was going on!
Rob

 

[lambuhere1]

Do send me for a dig at my end

ram.prakash@geind.ge.com

 

[Nikita6003]

well - my mailbox is still empty ... ;-)

Cheers
Nikki

 

[xlbo]

Without seeing the file - gotta guess that the PROJECT is protected

If you goto EDIT from the macro menu, are you asked for a password ?? Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[coachj]

I found out the spreadsheet had hidden worksheets. These hidden worksheets contained the values that populated the dropdown boxes. Went to Format - Sheet - Unhide and selected each hidden worksheet. Was then able to change, update, modify the cells in the unhidden worksheets and this did the trick. Thanks for the help.

 

[combo]

xlMacroVeryHidden!!!

 

[Nikita6003]

geez ... MS never ceases to amaze me

Macro.Find Method:=xlHowCanWeJerkAroundUsers

Nikki