Hi I am very new to visual basic and wondered if anyone knows how I can get Excel to do the recalculate F9 keystroke ? I dont want the user to be able to automatically recalculate but in some instances I want Excel to automatically calculate the cells and think programming the F9 keystroke might work.

Thanks
Amy
xx