Hi everyone

I have joined this forum to seek help in my hour of need! I am using Excel 2003 at home but Excel Mac 2004 which does seem to be a little..special at times.

I am just starting to learn VB and I have decided I need some expert help. If I describe what I am trying to do first...

What I want is to be able to;

Open a workbook
Click a form control button (Sheet 1)
This prompts several Web Queries to be executed (Approx 8 of them Via VB)
1st set of data that is downloaded to be listed on Sheet 2
Sheet 2 is renamed and then hidden
Sheet 3 is also renamed and a pivot table appears
A new sheet (Sheet 4) is opened with a new name
Second set of data loads
Tab for sheet 4 is renamed and Sheet becomes hidden
New Sheet (Sheet 5) is displayed
Tab for sheet 5 is renamed and pivot table appears
And so on for the remaining queries.

I have had limited success with various aspects of this. I have managed to input a form control which then loads 1 web query. However it won't load more than one web query!

Further to this, when I open the workbook the macro runs automatically and downloads it onto sheet one. Even though within the code I have managed to get it to select sheet 2 and even get it to rename, it seems unless I click the button it does its own thing. Unfortunately I do not have any code as it is at work!

I am a little stumped as to what to do next. I am going to post what code I have but I think as none of it worked properly I deleted it all!

I appreciate this is a large task. I would appreciate any help!

Thank you very much.

Regards
Peter