Take the 2-minute tour ×
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? –  vba4all 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. –  vba4all Aug 28 '13 at 10:28
1  
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

1 Answer 1

up vote 2 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
1  
That did it. Thank you! –  RLH Aug 28 '13 at 12:23

Your Answer

 
discard

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.