Having a problem in using MS Office.

Asked By Sheena Lao 10 points N/A Posted on - 04/03/2012

I have 12 Microsoft Excel worksheet in a workbook. I want to use the command button for each sheet. Can you help me please?

• Status: Open
• Question Views: 830
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office

Answered By MILTON Njundi 0 points N/A #115598

Having a problem in using MS Office.

To use command button for each sheet on Microsoft Excel worksheet  then follow these steps:

1. On a Microsoft Excel click "Office File" and click "Excel Option".

2. On the Excel Option click "Customize the ribbon" and at the Main tab click "Developer" if not yet check and click  "OK".

3. On the Developer tab click "insert" to bring up list of controls you want to insert and click "buttons".

3. Click the worksheet you want your command button to be place.

4. Then choose macro for command button and click "OK".

5. Right click and click "Format control" to format how the button looks.

Now command button is solve. Just repeat this procedure on each work sheet for command button.

See sample on attached file.

 

 

 

About MILTON Njundi

Questions
1

Answers
22

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 04/10/2012
• Question Category: Microsoft Office