VB Toolbar in Excel 2007

[Khan]

Hi,

I'm new to excel 2007, i have created a vb command button on excel
sheet but that button is by default in design mode (if i click on
button it takes me to code). I want the button in run mode, normally
in excel 2003 there is vb tool bar and from there we can change the
status of any vb control.

appreciate your response.

Thanx.

 

[Rick Rothstein \(MVP - VB\)]

Click the Office Button (the round one in the upper left corner, click the
Excel Options button at the bottom of the dialog box that appears and, in
the Popular option, put a check mark in the item labeled "Show Developer tab
in the Ribbon" located in the "Top options for working with Excel" section.
After you click OK, you will find a "Developer Tab" in the Ribbon where you
can do what you asked about.

Rick

 

[Khan]

Click the Office Button (the round one in the upper left corner, click the
Excel Options button at the bottom of the dialog box that appears and, in
the Popular option, put a check mark in the item labeled "Show Developer tab
in the Ribbon" located in the "Top options for working with Excel" section.
After you click OK, you will find a "Developer Tab" in the Ribbon where you
can do what you asked about.

Rick









- Show quoted text -

Thanks Rick, it works.