ctrl D calculating a sheet

[Chrissirhc]

Hi,

Is there anyway you can make ctrl D calculate a workbook without having application.onkey in a macro somewhere??? I've searched through all the xla addins and the workbook modules for onkey and cannot find one. Any ideas?

Thanks,

Chris

 

[DirkStruan]

I can't say I've ever used application.onkey (so apologies if the following is what you are trying to avoid), but can you not just write a one line macro

Sub calc
Calculate
end sub

and then assign the shortcut of control+d under tools/macros?