View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rebecca[_6_] Rebecca[_6_] is offline
external usenet poster
 
Posts: 1
Default Prompt User to Enter Data with a macro

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?