View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Input Box to rename sheet?

see response in .misc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tjtjjtjt" wrote in message
...
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