Excel Sheet.Copy Method (Excel 2003 SP2 )
 

Hello,

Excel 2003 (SP2):

In my macro i am creating new workbook and using copy method to copy
sheet format, page setting etc to newly added sheet. I am not using
template as there are many users and it is not feasible to provide
every body to access share template on a server. Hence i decided to
follow sheets.copy approach.

But my need is to avoid user from displaying/hiding data filling
activity in sheet; new sheet insert process hence i am using
Workbooks.IsAddin and oWB.Application.Windows(1).Visible to hide
workbook from user. But due to this Copy method is failing.

I tried ScreenUpdating & Interactive properties but still i am able to
see the updates made to workbook.

Is there any proper way to avoid updates to be displayed/hideen from
user.

Any help is highly appreciated.

Regards,
Amit