x=inputbox("Enter data")

"Rebecca" wrote in message
...
I am setting up a workbook where new sheets will be added
for new years. Can a macro prompt a user to enter the new
year when the sheet is right clicked to rename it?