Hi,
I am trying to get my brain around how to take the information from an input
box and use that data to rename the excel sheet.

For example, I want to prompt for a week number and then rename the sheet to
be that week number.

I then want to use the Week number for other things.

I am still fairly new to excel programming and just can't figure it out at
the moment. Any help would be great.

Thanks