VBA code auto load and auto closing

I have put the following code in a module in a workbook of 6 worksheets but with only 2 worksheets showing. Worksheets need to be protected. As soon as user clicks opens the file, it opens immediately, adds one to the qtn number and closes immediately saving a new file with the new qtn number. What i wish the code to do is that when user opens the file it opens up, but then stays open until user input new data, and then when user clicks a button the new qtn file with the incremented qtn number is created and saved.

Please Login or Register  to view this content.

Can someone indicate what I am doing wrong and how should the code be to have it doing what I need it to do.

Thks
Paraxis

can you attach the workbook, and stick to one question at a time.

The code needs to be tidied up, you don't need to select the ranges. The clearcontents could be done with an array.

I would store he number in the Registry.