Create event to run multiple Macro's

[WopkeHettema]

Hello,

I'm using Excel now for a long time for the company I work for and of recently i started to experiment with macro's to do the tedious work of copying and pasting the first 10 rows of my sheet whenever I run out of space on my first printable area I would really like to have an automated event that askes me if I want an extra "page"to be added under the first page.

I hoped it was possible when I for instance pass row 40 that it would give me a popup box to ask if i want an extra "page" and then automaticly copy the first 10 lines of code to a cell below the first "pageline".

And secondly I would like to create a new Save macro to check the filename to be anyting else as the file I opened and give me a box that let's me enter a file name and then save the file under the given name as a workable excelfile and a PDF File.

I hope I have given you enough information on my situation and i hope you can help me out here.


P.S. I'm using Excel in pageview so that's why i refer to pages.

Sorry for the horrible english but I'm not a native speaker