Copy sheet from addin
 

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

Copy sheet from addin
 

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

--
Message posted from http://www.ExcelForum.com

Copy sheet from addin
 

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

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


---
Message posted from http://www.ExcelForum.com/

.