VBA - Start and stop multiple sheet calculation from 1 sheet.

Occasional Contributor

Hey out there :) 


I'm trying to figure out, how to buld up a VBA smartes to, choose what sheet that should start calculating, based on a targeded rage. (from a list ex. sheet3.cell(3,3) )


I have done this in the macros, with show and hide cells.


Is there a smart way to do this. and if yes. shows i do it in the module, the Workbook or in the individual sheet in order to make it work. if its to confusing i can past a marco that work wit showing and hiding cells with multiple options/combinations. 


Best regards Julio César

0 Replies