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

Copper 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