VBA: calling a macro from a different sheet

[Puppies72]

Hi all,

I have a macro linked to a button on sheet "Terrain", I have another macro on sheet "active max" - both work fine - seperately.

What I want to do is hide sheet "active max" and run it's macro at the end of the current macro I have on sheet "terrain".

I know I can do this using Application.Run...the problem I am having is that my macro on sheet "active max" does a lot of autofill; jumping around the sheet; calculations and copy pasting of values and when I call it from my "terrain" sheet macro it affects cells on the "terrain" sheet and not the "active max" sheet.

I have With Sheets ("...") and End With on my "active max" sheet macro but is there any other way to ensure that it only calculates on that sheet and not the sheet where the macro is being activated from?

 

[freesurf]

Try

Worksheets(“active max”).Calculate

more generally, you can find details on restricting what's being calculated here:
http://www.decisionmodels.com/calcsecretsh.htm

 

[Puppies72]

Thanks for that but it doesn't make any difference.

The sheet "active max" doesn't need to be calculated - the macro on that page needs to be run and affect only that page - as it is if I call it from within a mcro on a different page using Application.Run it is affecting cells on the page I am calling it from.

I checked your link and there i snothing I can see there either as it is not really a calculation issue