Dear Excel Masters, I need your help. I want to insert a new worksheet through macro and want to change that sheet name with pre-defined name in master sheet.
Whatever name i defined in mastersheet, macro will insert that worksheet in my work book. Further, if work book have that name worksheet than macro will indicate that "The same name is as another sheet" and user can define a new name through user box for new worksheet. I think it is possible through macro. Please help me. Thanks in advance. Regds, Manish -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
