Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
Hagan, have a look here for some code to do it,
http://www.google.com/groups?threadm...GP10.p hx.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" wrote in message ... 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
|
|||
|
|||
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...GP10.p hx.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" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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...GP10.p hx.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" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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...GP10.p hx.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" wrote in message ... 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
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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...GP10.p hx.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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |