run a macro to Force Calcuation for a range in another workbook

[pauluk]

Hello all,

Need a little help with the following.

I have a form which the user enters a date, after entering the date the macro then opens "Year workbook", it turns off calculation.

The date the user enter relates to the sheet in the "Year workbook" which i will be selecting all cells on the sheet and forcing calulation for this range.

but i can't seem to get it to work, the code is below:

Please Login or Register  to view this content.

Thanks in Advance

[Trebor76]

Hi Paul,

Not sure "what you can't get to work", but have a look at my attached solution which if doesn't solve the issue(s), will hopefully point you in the right direction.

HTH

Robert