Thread: Macro to have user enter new worksheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MMH MMH is offline
external usenet poster
  
Posts: 14
Default Macro to have user enter new worksheet name
Hello all

At the end of my macro, I want the user to rename the active worksheet. Is
there some way I can do this in VBA.

Failing that, how would I get a message box to appear reminding the user
they need to change the worksheet name.

Thank you in advance.
MMH
Reply With QuoteReply With Quote