Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

Can you post the code?

x-rays wrote:
Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

Usually that happens when the Application.EnableEvents is turned off.
To check just go to the immediate window and type
? Application.EnableEvents

"x-rays" wrote:

Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

I guess it would on your code.

NickHK

"x-rays"
groups.com...
Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

Hard to say from your limited description but my best guess would be that
your code probably toggles Application.EnableEvents on and off. If your code
turns events off and does not turn them back on again then No events will be
firing. Try running this little procedure and see if it helps

Sub ReEnable()
Application.EnableEvents = True
end sub

If that fixes your problems then you need to find out why your events were
turned off without being turned on again. If you need help with that just
reply back...
--
HTH...

Jim Thomlinson


"x-rays" wrote:

Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

Now says that I have to enable the macros and refer to online help

Jim Thomlinson wrote:
Hard to say from your limited description but my best guess would be that
your code probably toggles Application.EnableEvents on and off. If your code
turns events off and does not turn them back on again then No events will be
firing. Try running this little procedure and see if it helps

Sub ReEnable()
Application.EnableEvents = True
end sub

If that fixes your problems then you need to find out why your events were
turned off without being turned on again. If you need help with that just
reply back...
--
HTH...

Jim Thomlinson


"x-rays" wrote:

Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?

Ok guys it works with the Application.EnableEvents = True

I had first to close and reopen the file.

Thank you all very very much!

Have a nice day (or night)!

x-rays wrote:
Now says that I have to enable the macros and refer to online help

Jim Thomlinson wrote:
Hard to say from your limited description but my best guess would be that
your code probably toggles Application.EnableEvents on and off. If your code
turns events off and does not turn them back on again then No events will be
firing. Try running this little procedure and see if it helps

Sub ReEnable()
Application.EnableEvents = True
end sub

If that fixes your problems then you need to find out why your events were
turned off without being turned on again. If you need help with that just
reply back...
--
HTH...

Jim Thomlinson


"x-rays" wrote:

Hello All,

Newbie question.

I wrote some code for a workbook and specifically I use the events of
the worksheet (I have 4 sheets) to catch the Selectionchange and
change. The first time the code was running fine but when I closed and
reopened the file the code did not run again.

What's going on?