Displaying a print menu of worksheets

[jopper1988]

Hello,

I have een little problem with a excel file. In the excel file is a VBA code that is combined with a button if someone click on the button a little menu shows with a multiple options of sheets that can be printed. Only the problem is when i hide the sheets the code doesn't see them anymore and the only i can print is the page where the button is placed.

Here do you have de code:

Please Login or Register  to view this content.

Can someone help me with this problem. I have this code from someone else but i need to change it to my wishes.

I'll hope you guys can help me.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)

[buran]

I think this should work

Please Login or Register  to view this content.

[jopper1988]

Hi Buran,

You are the best :-). This works like a charm.

[buran]

great. Don't forget to mark the thread as SOLVED if it's what you wanted :-)