Update code for Print function on Form in Visual Basic

[TheDude001]

All,
I have an excel workbook that contains several pages, and has a "main menu" in that allows you to hide/unhide tabs, and print individual tabs... The issue is once I change the tab name, button to hide/unhide no longer works and the button to print the tab no longer works. I have very limited knowledge on VB, and am figuring it out as I go... Below is the code... My guess is I can update the code to refer to "sheet1" as oppose to the actual tab name, but want to ensure I do it correctly. The code below is for the "print button" for the overview page, which is sheet19. I appreciate the help in advance.

Please Login or Register  to view this content.

[TheDude001]

anyone????

[royUK]

We can't help without the full code. It looks like you specify a sheet called "overview". For good coding using sheets you shouldn't use the sheet name - see this for a start.

[TheDude001]

royUK,
Thankyou for the info/link... That was my assumption. I am working on a workbook that has 60+ tab and over 1500 line of code just for the "main menu" form, hence why I didn't post all the code. All code refers to sheet tab names as opposed to sheet code names, which is the problem. Is there a relatively easy way to correct this ( I assume not), or should I just deal with the limitations in its current state? Thanks again for the assistance.

[royUK]

Use Find & Replace within VB Editor to correct the use of Code Names.

1500 lines of code for one form seems excessive, as does 60+ tabs

[TheDude001]

Needless to say, it is a complex model I use for work and yes, it is big. I am beginning to think too complexe for its use... Based on the orginal code posted above, would it be as simple as replacing "Overview" with the sheet code name? Or does the preceeding code need changed too. I appoligize for the ignorance... I am obviously over my head, but am learning slowly.

[royUK]

Try replacing that reference to overview & any other sheet names. Use Debug frequently to check for errors caused by the replace

[TheDude001]

Thanks, will give it a try.