Prompt User to Enter Data with a macro

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

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?
 
there is no event associated with renaming a sheet, so I would say no.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding footer to all existing sheets in workbook and also to newsheets which is added 1
Similar Book to Book Code, one works other does not 11
Prompt the user for an existing sheet 4
macro to save file as 4
prompt password for a worksheet 5
Macro to copy value in field and insert it into filter 2
preventing referencing hidden cell 3
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top