Excel Move function triggers sheetCalculation

**Anandi** · 02-12-2009, 05:53 AM

Hi,

I have a sheets which have lot of formulas. Using Raw_Move function my logic tries to move the same sheet from one position to another. While doing same,Some sheets position get change and triggers sheet calculation for those sheets. But If do the same thru Move Or Copy menu options its not trigeering.

Can you,please tell me why sheet calculation is triggering in using raw_move function?.

Currently I am setting calculation to xlManual to disable the sheet calculation.

Thanks

**Andy Pope** · 02-12-2009, 05:56 AM

Hard to tell without seeing what Raw_move does.

Have you tried disabling events whilst the function executes?

**Anandi** · 02-12-2009, 06:18 AM

I tried and its working fine. In my logic I have another sheet to monitor added sheet name in formula format to capture the sheet rename events. If I disable that logic then I am not getting any Sheet Calculation from raw_move.

I suspects raw_Move tries to set some name property?

Thanks