Attaching Standard Excel Command to Button

**laguna92651** · 01-18-2012, 12:46 PM

I would like to attach a standard Excel command to a form control button. Specifically I want to place two buttons on a worksheet, one would execute the Pivot Table Refresh command and the second would execute the Form command for a Table List. I know these commands are easily available on the right click menu or the Quick Access toolbar, but this still isn't easy enough for the end user. I can't find how I can just attach these commands to a button, thanks.

**OnErrorGoto0** · 01-18-2012, 12:51 PM

The simplest method is probably to simulate clicking the relevant button

Please Login or Register  to view this content.

for example.

**laguna92651** · 01-19-2012, 06:08 PM

So I would attach the supplied code to a button? Is there a listing of what the various commands are or is just the name in the tooltip (for example Form command to create new record in a table) or the menu label?

**OnErrorGoto0** · 01-20-2012, 02:46 AM

Yes.
If you hover over the item in the QAT customisation dialog, the tooltip is the name you need. There is also a listing in a workbook available via the Ribbon section of Ron de Bruin's site (www.rondebruin.nl)

**laguna92651** · 01-21-2012, 09:15 PM

I tried the code:

Please Login or Register  to view this content.

and got the following error.

runtime_error.JPG

I'm trying to refresh a pivot table with the button. Any further thoughts?

**royUK** · 01-22-2012, 05:13 AM

Try this to refresh a specific PivotTabel

Please Login or Register  to view this content.

To refresh multiple PivotTables

Please Login or Register  to view this content.

**OnErrorGoto0** · 01-22-2012, 05:36 AM

Did you have a pivot table selected?

**laguna92651** · 01-22-2012, 05:07 PM

This code worked great.

Please Login or Register  to view this content.

How would I automatically refresh the pivot table whenever I add, edit or delete a record in the source list.

**royUK** · 01-23-2012, 02:54 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save