Would like to activate the status bar via shortcut keys and then toggle
through the sum, count, average, etc... options. How can I avoid the
right-click action.

There is no shortcut key for this. You can assign the following macro to a
shortcut key. Change the '2' to the item number in the list you want to
activate.

Application.CommandBars("AutoCalculate").Controls( 2).Execute


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)




"Jesse W" <Jesse wrote in message
...
Would like to activate the status bar via shortcut keys and then toggle
through the sum, count, average, etc... options. How can I avoid the
right-click action.