Having a problem in using MS Office.

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #115598

Having a problem in using MS Office.

qa-featured

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.

 

 

 

Related Questions