Hi all,
I recently discovered EnableCalulation T/F option and thought my issues were solved. The 2 issues I have is that EnableCalculation defaults to True when the workbook is opened and the Calculate Sheet option doesn't work when EnableCalculation is False.
I need just 1 sheet in the workbook to do as explained below:
I would love a Macro that sets EnableCalculation to False for a specific sheet when the workbook is opened and then set to True when that specific is opened and False again upon exit.
Your help is greatly appreciated!
I recently discovered EnableCalulation T/F option and thought my issues were solved. The 2 issues I have is that EnableCalculation defaults to True when the workbook is opened and the Calculate Sheet option doesn't work when EnableCalculation is False.
I need just 1 sheet in the workbook to do as explained below:
I would love a Macro that sets EnableCalculation to False for a specific sheet when the workbook is opened and then set to True when that specific is opened and False again upon exit.
Your help is greatly appreciated!