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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>> >
>>
>>
>>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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?
> >> >
> >>
> >>
> >>
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > 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?
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>