Hi

I have a macro that will delete the existing worksheets and then will add many worksheets and populate all of them.

The problem is whenever i open the worksheet, "adding and populating the data" is shown to the user.

Is there is any way to show the excel sheets after populating them

thanks in advance

__________________
Try Try Try Until You Succeed

You could just turn of the screen updates..

    application.screenupdating = false

when updating is complete turn the updating back on to show the new pages

    application.screenupdating = true

or hide the app

    application.visible = False

and then show it again

    application.visible = True

Thanks shattered.

I have used application.screenupdating and that is working fine.

Regards,
S.Sridevi