Copy sheet from addin

[jacob]

Hi,
I have an addin which include some custom worksheets
which are copied from the .xla to a new workbook using

ThisWorkbook.Worksheets("CustomSheet1").copy

However, the copy operation takes quite a few seconds to
accomplish, much longer than f.ex. to copy the same
worksheet from an existing normal workbook to another. Is
this just the way it is or is there anything I could do
to make things happen faster?

Any help appreciated.

jacob

 

[BrianB]

Just the way things are.
Setting Calculation to manual could save time

 

[jacob]

Hi,
If nothing else, it is good to know. Thx.