Prompt User to Enter Data with a macro

[Rebecca]

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?

 

[Don Guillett]

x=inputbox("Enter data")

 

[Tom Ogilvy]

there is no event associated with renaming a sheet, so I would say no.