userform for printing

Forgot to attach the file. Here it is.

Just had another idea on making the userform, if i have one userform with 10 check boxes and then rename them acording to which sheet they are to print, then turn the others to not visible. Im working on it now but any help is appreciated.

Thanks, I have used some of the code and the userform ideas from that to make mine work.

Im still having trouble with creating the sheets, im still working on it but im very slow with this, im looking everything up.

Wow, thanks for that, they are pretty handy. and that link is also a great help.

I have worked out my print thing as you can see in the attached file. Its there to print a group of files for each station(colum C) the code only needs to be written once so im happy with that. Better than my other idea.

Adding the sheets is only something im doing for myself, its not necessary, its just for me to learn and have fun with. What I want to be able to do is have the macro run which would create a sheet and rename it for the headings found in the rows. There will be 2 templates one for motors and one for contactors. I was hoping to have it take Colums C:E use thoes headings and make a sheet with that name from a copy of either a motor template or a contactor template.

The problem im having is getting it to fetch the data from a merged cell, i know you all hate merged cells and im starting to realise why, but im having fun trying to work out how to do it.

I have started on some code but havnt got really far, just starting to get the hang of formatting it correctly.

If you have any hints that could help me it would be great.

Thanks again.

Thank-you,

What I wanted from the macro is what you have there looped to do that whole contents page, C3:E48 so 46 sheets. Ill have a play with what you have there and see what I can do.

Thank you very much for this, its definately pointing me in the right direction.

Ok thank you all for your help, I have finished the code now, it does everything I wanted, it might be a bit bulky and over the top but it was fun.

If there are any things I should change in here please let me know, I want to do more so any hints that will make things easier for me ( and you when I need help again ) please let me know.

Here is the code.

Please Login or Register  to view this content.

I have also attached the worksheet, just select E3 in the contents pages and run CreateSheets to see what it does.

Thanks again everyone

good for you.
code is a bit bulky, but as long as it works, then who is to blame :-)
The more code you generate, the more you learn and the better the code gets. (at least I hope so :-p)



please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!