Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Name Worksheet Dialog box (English)

    Hi,
    New user just trying to do a simple task but don't know how to go about it. Can I write a code to select the current worksheet without specifying the worksheet name and prompt for a name change?

    Thanks!

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Name Worksheet Dialog box (English)

    Th efollowing line of code will prompt for a name and apply it to the actve sheet. You should be aware that it is very easy to generate an error with this type of code, e.g. entering the name of an existing worksheet.<pre>ActiveSheet.Name = Application.InputBox("Enter WorkSheet Name")</pre>

    See this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=vb&Number=73947&page=&view= &sb=&o=&vc=1>recent thread</A> for ideas on how to deal with the possible errors.

    Andrew C.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name Worksheet Dialog box (English)

    Thanks so much for such a fast response!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •