View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tjtjjtjt[_2_] tjtjjtjt[_2_] is offline
external usenet poster
 
Posts: 3
Default Input Box to rename sheet?

Can I create a macro that uses an input box to rename a Worskheet? I'm trying to combine several macros into one macro. So far, renaming the sheet has been the hardest thing to incorporate. I received an answer earlier on how to rename the active sheet to the value in the active cell. Now, I'm looking for another variation.
Can I create a macro that uses an iput box to rename a Worskheet?
Any help would be most appreciated!
tj