Hi,
I have four worksheets and I require 3 to be automatically calculated but the forth worksheet I need to be excluded when automatically calculating (Ill press Shift F9 to manually calculate it)
The Names of the worksheets in VBA are:
Sheet 1 (Summary)
Sheet 5 (1129)
Sheet 6 (1130)
Sheet 7 (1240)
I need the sheets 1129,1130 and 1240 set to automatic and the Summary sheet set to manual
Can anyone supply me with the VBA code?
You might want to have a read through the below first - just so you're aware of all the connotations of what it is you're looking to do
http://www.decisionmodels.com/calcsecretsh.htm
(author - Charles Williams MS Excel MVP)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks