Consulting

Results 1 to 4 of 4

Thread: Border war

  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Border war

    I created a style that takes away borders and changes the font in a range of cells. That's not the problem.

    When I try to reverse it with the opposite of the style I used and it puts borders around the cells inside the range which has a border around it.

    So is there a way to just reverse the style I used to take away the borders that were there originally and revert back to what it was before I applied the style?

    WB attached. Cells in question are on the Direct Bill Only tab. Range C22:F25.
    Peace of mind is found in some of the strangest places.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I wouldn't think so. A style overlays that format, it doesn't remove some added format.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    So I am up the creek as it were?
    Peace of mind is found in some of the strangest places.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If you need to do it that way yes. What I did was to create a styles addin, and one of the functions was a toggle through a series of borders. So it was easy to set a border on cells, but it was just as easy to set it to another.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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