Taking Too Much Time Vba Code

[HaroonSid]

hello, everyone

This code is taking too much time, plz give the solution

Please Login or Register  to view this content.

thnx

[bakerman2]

try this at top of code.

Please Login or Register  to view this content.

This at the end.

Please Login or Register  to view this content.

[kev_]

Try this

Instead of looping through all the sheets, this selects them all together and applies the printing set-up in one hit.

Please Login or Register  to view this content.

[HaroonSid]

thanx for repling

but none method is working for me

[kev_]

Excel holds page setup details separately for each sheet. So if you want to change lots of sheets from the default then it will take time.

Suggestions

1. Amend default settings:
When Excel opens a new worksheet, it opens a default file and takes all its settings from there.
If most of your files require the page set-up per the above macro, then amend and overwrite that file.
(The file on my system is called Book1.xltx and is found in the XLstart folder)
OR
2. Automatically introduce correct settings when new sheet added
Create a macro to add new sheet with your chosen settings and run the macro to create the sheet with correct settings in the first place

eg

Please Login or Register  to view this content.