Re-assign Calc Sheet keyboard shortcut?

T

TimGolobic

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.
 
J

JE McGimpsey

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.
Click to expand...

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

http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.
 
J

J Laroche

JE McGimpsey wrote on 2005/02/13 12:16:
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

http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.
Click to expand...


Or you can reassign Expose's keyboard shortcut in the System Preferences.
Note also that Cmd-= can also be used, although it calculates all open
workbooks, not only the active sheet.

JL
Mac OS X 10.3.8, Office v.X 10.1.6
 
Top