close

I have a userform, and when I load it - the cells =Rand() keep calculating
automatically and the whole screen goes blank. Is there any way to stop the
cells from calculating automatically when I load the userform?

Thanks for your help.


This might work

You can use this before the load:

Application.Calculation = xlManual

After load is done you can turn it back to automatic:

Application.Calculation = xlAutomatic--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=536080

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄