Need Help - Quality Check of macro code (Already created)

[kets0985]

Hello,

I have created a spreadsheet wherein I have used lots of codes to satisfy my objectives.

Just to brief you, I have created Code for following requirements:

1) Save Activesheet
2) Excel SaveAs Macro Prompt for path, Cell as filename, Close Original file, Open New File
3) Add new Sheet by clicking on button, which prompt for sheet name and search for duplicates. This code also add the newly created sheet name to Table of contents.
4) Created code for Table of contents, which will support point no 3.
5) Created code to print all filled sheet, which first set the print area, and then the other settings for print preview.


With these codes, I have also used some functions, for examples:
In sheet Main_1 range(D31) has data validation for A & B
When A is selected the last two rows of table in page 2 changes.


But somehow this is not happening, until the select is refresh of some value is entered in another cells.
Also the sheet functioning has slower down, and it take time of blinks often when open, activated or when print command button clicked.

Also the sheet is on page view layout, so when I give command to print thru button, and then close the print preview and return back, the sheet does not go back to the page view layout.

Just to inform you, i have used lots of conditional formatting to change color when particular value is select in main sheet, test 1.

Could somebody please help me to verify and check the macro codes thoroughly, if there is some minute or may be major change which i have not done.

Also the file size has been increased, dont know why?????????

Tool_Ketan_TEMPLATE.zipTool_Ketan_TEMPLATE.zip

If this get resolved and the sheet functioning become smooth, then it will be really appreciable.

Regards,

Ketan Bhole

[alansidman]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Cross Posted at: http://www.excelfox.com/forum/f2/nee...-created-1273/