Creating a repoting workbook with only one worksheet

There are more worksheets in this workbook, but they are hidden. There is a macro that runs automatically when you open the file. Open the file and press ALT + F11. You will find a lot of program code there. Check the 'ThisWorkbook' module and 'Module1' to see the code which makes it appear like one worksheet.

yeah, you right Mr, Just see, it's not easy to find that hidden worksheets, so that's why I post it and would to know how I can creat a thing like this or is there any tutorial that can help me.

Thx

The file you have is a good start I think. Just study the code that is inside.

Also, it is a bit complex task if you don't know anything about vba yet, so maybe you should start with smaller challenges.

should I start to create all the worksheets I need or start to just by typing programme with the VBA code? do u know how this is made or you are just trying to find it out too? this solution you propose I realy don't know how it could help me!!!

Thx

What exactly do you want? You want only one worksheet to appear? Saying "I want a workbook like this" is very general...

I suggest starting by making the worksheets first. The menu and VBA coding can be done later.
No, I haven't done anything like this before, but with some practice I might be able to do it.
I wasn't proposing a solution, I just told you where to start. If this doesn't help and you don't have a specific question, I can't help you better.

edit: [double post]

I would like to know where should I start, to built things like this, is there any tutorial that can help I.

Bless

Happy reading.

http://www.excelforum.com/excel-prog...materials.html

Thx, thx Thx so I will start now good!!!
Bless