I was able to assign To WorkSheet the SelectionChange event.

It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
1st worksheet. ???

Thank You,

cut/paste

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"G" <(E-Mail Removed)> wrote in message
news:870C97F9-3951-4FDE-8C84-(E-Mail Removed)...
>I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to
> my
> 1st worksheet. ???
>
> Thank You,
>
>

In the VB editor window, there should be a frame on the left hand side that
displays the project objects. If it's not showing, Ctrl-R will bring it up.
You'll see the name of your workbook as one of the VBAProject folder items.
Under that (when uncolapsed), is a folder titled Microsof Excel Objects,
under which you find the sheet and workbook objects in your file.

Double click the sheet where you want to add a Selection_Change event to
open its code window. With that frame's upper left dropdown, select
Worksheet. With the upper right dropdown, select SelectionChange.

"G" wrote:

> I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
> 1st worksheet. ???
>
> Thank You,
>
>

You may be able to use the Workbook_SheetSelectionChange (in the ThisWorkbook
module).

Or even put a common routine in a general module that each
worksheet_selectionchange event calls (passing nice parms).

(If it's a small procedure and I only need for a couple of sheets, I'd follow
Don's suggestion!)

G wrote:
>
> I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
> 1st worksheet. ???
>
> Thank You,

--

Dave Peterson