Thanks Tom, I thought it would be simple. When would you use a toggle button
and not a command button?

Regards.

"Tom Ogilvy" wrote:

Use a commandbutton instead of a Toggle button. Your Toggle button is
functioning as designed.

--
Regards,
Tom Ogilvy


"Jurrasicway" wrote in message
...
Hi, This must be a fairly simle one for all of you Exel Guru's. When I
click
on my Toggle Button to change to antother sheet it stays depressed. When
I
click it again and go back to the front sheet it looks normal. How do I
ensure that it resets itself automatically. Must be easy but its driving
me
mad!!!

Thanks