Developer excel for mac module

broken image
broken image

You may even search around and learn how to ungroup the Textboxes (highlight the Textbox, look at the ribbon where it says Drawing Tools, then click the Format tab there). You will need to click around on the nested Textboxes until you get the one you're after to actually show as highlighted (Hint: Try right-clicking the text itself). Then you will mess around for awhile and try to recreate the original object without the macro defined so it will quit running the macro every time you try to click the nested Textbox. Yes, Shape not Textbox, because Excel doesn't like to make the distinction too clear. Of course, you will wonder how it is working if there is no macro already assigned to that Shape. Choosing that opens a dialog which allows you to make a New macro or Record it. In this case, you can get into Design Mode as explained above and this will give the option Assign Macro when you right-click the Textbox. And not just Textboxes, but grouped Textboxes. Then you have the joker who didn't use controls, but used Textboxes instead.