Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Validation list (XP)

    Is there a way to "allow a list" in multiple cells on multiple sheets within the same workbook - of course I want to do this in a zillion cells at the same time with one list . . .

    ???????????????

    Aunt Linda

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validation list (XP)

    You can only set validation for cells on one worksheet at a time.
    One way to set validation on mutliple sheets relatively quickly is:
    1. <LI>Select a range of cells on one sheet.
      <LI>Select Data | Validation...
      <LI>Specify the validation settings.
      <LI>Click OK.
      <LI>Activate another sheet.
      <LI>Select a range of cells on this sheet.
      <LI>Select Edit | Repeat Validation or press Ctrl+Y.
      <LI>Repeat steps 5-7 as needed.
    Another option would be to write a macro that loops through worksheets and sets validation.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation list (XP)

    Thanks again, Hans. Will give it a shot - but have no experience writing macros so that's out for now.

    Please contact Microsoft and tell them I need a feature that will allow me to set validation for cells on more than one worksheet at a time - I'm sure you have vast influence with Mr. Gates et al . . . . lol.

    Have a great day

    Aunt Linda

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validation list (XP)

    I have no contacts inside Microsoft, and no influence at all!

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation list (XP)

    I'm kidding!!!!

    And I know that you know that - still haven't had a chance to try your suggestions but will soon . . .

    Again - thanks

    Aunt Linda

Posting Permissions

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