Re-assign Calc Sheet keyboard shortcut?

External Since: Feb 13, 2005 Posts: 2

I have looked under all of the keyboard commands in the Customize menu,
but can't find Calc Sheet to map it to a different key combination.

It's currently under Shift-F9, but that conflicts with my newly
installed Panther OS and the Expose feature.

Thanks for the help.

External Since: Mar 07, 2004 Posts: 3828

In article <1108312622.929854.136040.DeleteThis@f14g2000cwb.googlegroups.com>,
TimGolobic.DeleteThis@aol.com wrote:

> I have looked under all of the keyboard commands in the Customize menu,
> but can't find Calc Sheet to map it to a different key combination.
>
> It's currently under Shift-F9, but that conflicts with my newly
> installed Panther OS and the Expose feature.
>

AFAIK, that command isn't exposed via the GUI. You can instead put this
macro in a regular code module in your Personal Macro Workbook:

Public Sub CalcSheet()
Activesheet.Calculate
End Sub

and assign a keyboard shortcut to it using Tools/Macro/Macros... and
clicking the Options button.

If you're not familiar with macros, see

<a style='text-decoration: underline;' href="http://www.mvps.org/dmcritchie/excel/getstarted.htm" target="_blank">http://www.mvps.org/dmcritchie/excel/getstarted.htm</a>

which, while written for WinXL, is pretty much the same for MacXL
(except that WinXL calls the Personal Macro Workbook "Personal.xls"),or
post back.