Problems with Controls Embedded in Worksheet

[chris brunt]

When I embed a control (eg Command Button) in a worksheet (even on a totally
blank workbook), it drastically slows down the time taken to execute
commands such as print, print preview, file close. As soon as I embed a
contol (which in itself has become slow), and then for example select print
preview of a range (including a range that does not include the embedded
control), the print preview page takes approx 15 seconds to appear and the
same delay will occur when closing the preview page. The execution of macros
associated to the embedded control appears unaffected.

thanks for any help

ChrisB

 

[Dave Peterson]

I'm not sure if this'll help, but those controls put stuff in your windows temp
folder. When that folder gets cluttered, then excel can slow down.

I'd close excel and clean up that windows temp folder and then retry it.