+ Reply to Thread
Results 1 to 6 of 6

Highlight cells with ctrl-click but only un-highlight one cell

  1. #1
    hagan
    Guest

    Highlight cells with ctrl-click but only un-highlight one cell

    When highlighting a number of cells using ctrl-click, and accidentally
    highlighting one incorrectly, how can I un-highlight it without losing my
    other selections and starting over?


  2. #2
    Paul B
    Guest

    Re: Highlight cells with ctrl-click but only un-highlight one cell

    Hagan, have a look here for some code to do it,

    http://www.google.com/groups?threadm...TNGP10.phx.gbl
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003


    "hagan" <hagan@discussions.microsoft.com> wrote in message
    news:81D7FE41-99C5-47AC-9142-8A1AD64A5B52@microsoft.com...
    > When highlighting a number of cells using ctrl-click, and accidentally
    > highlighting one incorrectly, how can I un-highlight it without losing my
    > other selections and starting over?
    >




  3. #3
    hagan
    Guest

    Re: Highlight cells with ctrl-click but only un-highlight one cell

    Paul,

    Thanks for the link. However, I'm at the point that BillB got to, where
    he said he couldn't find the personal.xls file and then how do you edit the
    Workbook_Open procedure?

    Hagan

    "Paul B" wrote:

    > Hagan, have a look here for some code to do it,
    >
    > http://www.google.com/groups?threadm...TNGP10.phx.gbl
    > --
    > Paul B
    > Always backup your data before trying something new
    > Please post any response to the newsgroups so others can benefit from it
    > Feedback on answers is always appreciated!
    > Using Excel 2002 & 2003
    >
    >
    > "hagan" <hagan@discussions.microsoft.com> wrote in message
    > news:81D7FE41-99C5-47AC-9142-8A1AD64A5B52@microsoft.com...
    > > When highlighting a number of cells using ctrl-click, and accidentally
    > > highlighting one incorrectly, how can I un-highlight it without losing my
    > > other selections and starting over?
    > >

    >
    >
    >


  4. #4
    Paul B
    Guest

    Re: Highlight cells with ctrl-click but only un-highlight one cell

    hagan, have a look here on getting started with Macros on David McRithchie's
    site
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    If you need anymore help post back
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "hagan" <hagan@discussions.microsoft.com> wrote in message
    news:2EF7EADC-FB1E-42F4-9D41-5DCB8CD519F4@microsoft.com...
    > Paul,
    >
    > Thanks for the link. However, I'm at the point that BillB got to, where
    > he said he couldn't find the personal.xls file and then how do you edit
    > the
    > Workbook_Open procedure?
    >
    > Hagan
    >
    > "Paul B" wrote:
    >
    >> Hagan, have a look here for some code to do it,
    >>
    >> http://www.google.com/groups?threadm...TNGP10.phx.gbl
    >> --
    >> Paul B
    >> Always backup your data before trying something new
    >> Please post any response to the newsgroups so others can benefit from it
    >> Feedback on answers is always appreciated!
    >> Using Excel 2002 & 2003
    >>
    >>
    >> "hagan" <hagan@discussions.microsoft.com> wrote in message
    >> news:81D7FE41-99C5-47AC-9142-8A1AD64A5B52@microsoft.com...
    >> > When highlighting a number of cells using ctrl-click, and accidentally
    >> > highlighting one incorrectly, how can I un-highlight it without losing
    >> > my
    >> > other selections and starting over?
    >> >

    >>
    >>
    >>




  5. #5
    hagan
    Guest

    Re: Highlight cells with ctrl-click but only un-highlight one cell

    Paul,

    Whew! That was pretty deep considering that I've never written a macro or
    used VBA. Finally got it working, and it's great. Thanks a lot for your
    help. Sorry I had to keep asking for instructions.

    Hagan

    "Paul B" wrote:

    > hagan, have a look here on getting started with Macros on David McRithchie's
    > site
    > http://www.mvps.org/dmcritchie/excel/getstarted.htm
    > If you need anymore help post back
    > --
    > Paul B
    > Always backup your data before trying something new
    > Please post any response to the newsgroups so others can benefit from it
    > Feedback on answers is always appreciated!
    > Using Excel 2002 & 2003
    >
    > "hagan" <hagan@discussions.microsoft.com> wrote in message
    > news:2EF7EADC-FB1E-42F4-9D41-5DCB8CD519F4@microsoft.com...
    > > Paul,
    > >
    > > Thanks for the link. However, I'm at the point that BillB got to, where
    > > he said he couldn't find the personal.xls file and then how do you edit
    > > the
    > > Workbook_Open procedure?
    > >
    > > Hagan
    > >
    > > "Paul B" wrote:
    > >
    > >> Hagan, have a look here for some code to do it,
    > >>
    > >> http://www.google.com/groups?threadm...TNGP10.phx.gbl
    > >> --
    > >> Paul B
    > >> Always backup your data before trying something new
    > >> Please post any response to the newsgroups so others can benefit from it
    > >> Feedback on answers is always appreciated!
    > >> Using Excel 2002 & 2003
    > >>
    > >>
    > >> "hagan" <hagan@discussions.microsoft.com> wrote in message
    > >> news:81D7FE41-99C5-47AC-9142-8A1AD64A5B52@microsoft.com...
    > >> > When highlighting a number of cells using ctrl-click, and accidentally
    > >> > highlighting one incorrectly, how can I un-highlight it without losing
    > >> > my
    > >> > other selections and starting over?
    > >> >
    > >>
    > >>
    > >>

    >
    >
    >


  6. #6
    Paul B
    Guest

    Re: Highlight cells with ctrl-click but only un-highlight one cell

    hagan, no problem, glad you got it working
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "hagan" <hagan@discussions.microsoft.com> wrote in message
    news:ACA35B01-6149-4968-8B64-296BC8AA9408@microsoft.com...
    > Paul,
    >
    > Whew! That was pretty deep considering that I've never written a macro
    > or
    > used VBA. Finally got it working, and it's great. Thanks a lot for your
    > help. Sorry I had to keep asking for instructions.
    >
    > Hagan
    >
    > "Paul B" wrote:
    >
    >> hagan, have a look here on getting started with Macros on David
    >> McRithchie's
    >> site
    >> http://www.mvps.org/dmcritchie/excel/getstarted.htm
    >> If you need anymore help post back
    >> --
    >> Paul B
    >> Always backup your data before trying something new
    >> Please post any response to the newsgroups so others can benefit from it
    >> Feedback on answers is always appreciated!
    >> Using Excel 2002 & 2003
    >>
    >> "hagan" <hagan@discussions.microsoft.com> wrote in message
    >> news:2EF7EADC-FB1E-42F4-9D41-5DCB8CD519F4@microsoft.com...
    >> > Paul,
    >> >
    >> > Thanks for the link. However, I'm at the point that BillB got to,
    >> > where
    >> > he said he couldn't find the personal.xls file and then how do you edit
    >> > the
    >> > Workbook_Open procedure?
    >> >
    >> > Hagan
    >> >
    >> > "Paul B" wrote:
    >> >
    >> >> Hagan, have a look here for some code to do it,
    >> >>
    >> >> http://www.google.com/groups?threadm...TNGP10.phx.gbl
    >> >> --
    >> >> Paul B
    >> >> Always backup your data before trying something new
    >> >> Please post any response to the newsgroups so others can benefit from
    >> >> it
    >> >> Feedback on answers is always appreciated!
    >> >> Using Excel 2002 & 2003
    >> >>
    >> >>
    >> >> "hagan" <hagan@discussions.microsoft.com> wrote in message
    >> >> news:81D7FE41-99C5-47AC-9142-8A1AD64A5B52@microsoft.com...
    >> >> > When highlighting a number of cells using ctrl-click, and
    >> >> > accidentally
    >> >> > highlighting one incorrectly, how can I un-highlight it without
    >> >> > losing
    >> >> > my
    >> >> > other selections and starting over?
    >> >> >
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1