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

%3CLINGO-SUB%20id%3D%22lingo-sub-1226879%22%20slang%3D%22en-US%22%3EVBA%20-%20Start%20and%20stop%20multiple%20sheet%20calculation%20from%201%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1226879%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20out%20there%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%2C%20how%20to%20buld%20up%20a%20VBA%20smartes%20to%2C%20choose%20what%20sheet%20that%20should%20start%20calculating%2C%20based%20on%20a%20targeded%20rage.%20(from%20a%20list%20ex.%20sheet3.cell(3%2C3)%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20this%20in%20the%20macros%2C%20with%20show%20and%20hide%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20smart%20way%20to%20do%20this.%20and%20if%20yes.%20shows%20i%20do%20it%20in%20the%20module%2C%20the%20Workbook%20or%20in%20the%20individual%20sheet%20in%20order%20to%20make%20it%20work.%20if%20its%20to%20confusing%20i%20can%20past%20a%20marco%20that%20work%20wit%20showing%20and%20hiding%20cells%20with%20multiple%20options%2Fcombinations.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%20Julio%20C%C3%A9sar%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1226879%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EVBA%20-%20Start%20and%20stop%20multiple%20sheet%20calculation%20from%201%20sheet.%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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