Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Excel document that I need to modify. This thing was created by a "guru" and has been locked down from almost any form of modification.

I have the master-password to access the VBA modules and, I assume, that might be all that I need to make any changes to this document worksheets.

The first worksheet of this Excel file is a switch board. It has a series of buttons that launch various VBA forms that are used for data input. I need to modify the properties associated with one of these buttons, but I can't figure out how to view the Properties dialog. How can I display it?

FYI, I have attempted to right-clicked this button many times, but I can't get a context menu to show up. What can I do to modify this button?

share|improve this question
what type of button is it? A form button or an ActiveX? Have you got your Developer Tab opened? – Meehow Aug 28 '13 at 9:06
@mehow: I'm not sure and no, I don't have a developer tab open. All I can say is that these buttons are on my first worksheet, they are not on a VBA form, and they located within cells but appear to "float" over worksheet. How do I open a developer tab/toolbar? – RLH Aug 28 '13 at 10:22
Apologies for my ignorance, the background for this spreadsheet was that it was created by a non-developer person, for a job that needed a MUCH more robust application. I'm writing the needed application but in the interim my users absolutely need some minor changes to the original spreadsheet. I've never used excel at this level and I'm a bit clueless as to how to do whatever needs to be done to make changes on my "switchboard" worksheet. I can change VBA code and forms, but this one form has me baffled. – RLH Aug 28 '13 at 10:26
it depends on the excel version, but try this way to open the Developer Tab. If that doesnt suit you just research it on google, it's really easy to find how. Once you have the Developer tab opened you will be able to go into the Design Mode and then you will be able to look at button properties. – Meehow Aug 28 '13 at 10:28
Aha! I see now. Thank you. Feel free to post an answer. After cutting on the Developer tab, I see that all I have to do is put the Worksheet in "Design Mode", much like Access and queries. – RLH Aug 28 '13 at 12:03

2 Answers 2

up vote 3 down vote accepted

Turn on the Developer Tab in Excel

Go into Design Mode

enter image description here

Right-click any control and View Properties

share|improve this answer
That did it. Thank you! – RLH Aug 28 '13 at 12:23

Then you have the joker who didn't use controls, but used Textboxes instead. And not just Textboxes , but grouped Textboxes . 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. Choosing that opens a dialog which allows you to make a New macro or Record it. Of course, you will wonder how it is working if there is no macro already assigned to that Shape. Yes, Shape not Textbox, because Excel doesn't like to make the distinction too clear. 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. 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). 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). Once the correct object is highlighted, the context menu should show a Macro already assigned to it and offer an Edit option. Now you will be able to begin to debug or modify the spaghetti code VBA doubtless left behind by the 'guru'. You may even search the definition of 'guru': a spiritual teacher, especially one who imparts initiation. Consider yourself 'initiated'.

share|improve this answer
wow. Seems like you worked with that person too. :) – mcw0933 Oct 1 at 15:04
@mcs0933 - I must have been in a foul mood. – B H Oct 13 at 3:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.