View Single Post
  #3   Report Post  
Bruno Campanini
 
Posts: n/a
Default

"TheRobsterUK"
wrote in message
news:TheRobsterUK.1vxi2b_1127675107.1271@excelforu m-nospam.com...

Hi,

Is there any way to freeze (prevent) a number of worksheets from
recalculating when a VBA macro is running?


Use properly in your macro:

Sheets("SheetName").EnableCalculation = True | False


Bruno