First of all, I'm using Excel 2002

I have some code like this:

Private Sub Worksheet_Deactivate()

'look for a value in a certain cell on the sheet the user just
deactivated
'if a certain value is there, go back to the sheet the user just
deactivated
'essentially, the user can't go to any other sheet unless they change
the value of a certain cell first

End Sub

The code works fine EXCEPT when the user clicks on a sheet with
grouped rows and/or columns that have any of those groups collapsed.
When that happens, Excel stays on the sheet they just clicked and
whatever cell was last activated blinks black and white.

This seems like a bug to me. Am I doing something wrong? Is this a
known issue?

Any help would be appreciated. If you need more detail, please let me
know.

Thanks.

Angela,

It appears that you need to disable events.
Use

application.enableevents=false

in the beginning of the routine & then change it to true before the routine
ends.
--
http://www.ExcelHelp.us
(E-Mail Removed)
888-MY-ETHER ext. 01781474



"angelasg" wrote:

> First of all, I'm using Excel 2002
>
> I have some code like this:
>
> Private Sub Worksheet_Deactivate()
>
> 'look for a value in a certain cell on the sheet the user just
> deactivated
> 'if a certain value is there, go back to the sheet the user just
> deactivated
> 'essentially, the user can't go to any other sheet unless they change
> the value of a certain cell first
>
> End Sub
>
> The code works fine EXCEPT when the user clicks on a sheet with
> grouped rows and/or columns that have any of those groups collapsed.
> When that happens, Excel stays on the sheet they just clicked and
> whatever cell was last activated blinks black and white.
>
> This seems like a bug to me. Am I doing something wrong? Is this a
> known issue?
>
> Any help would be appreciated. If you need more detail, please let me
> know.
>
> Thanks.
>

I did that. Still doesn't work.

On Nov 25, 7:56*am, galimi <e...@HelpExcel.com> wrote:
> Angela,
>
> It appears that you need to disable events.
> Use
>
> application.enableevents=false
>
> in the beginning of the routine & then change it to true before the routine
> ends.
> --http://www.ExcelHelp.us
> e...@ExcelHelp.us
> 888-MY-ETHER ext. 01781474
>
>
>
> "angelasg" wrote:
> > First of all, I'm using Excel 2002
>
> > I have some code like this:
>
> > Private Sub Worksheet_Deactivate()
>
> > 'look for a value in a certain cell on the sheet the user just
> > deactivated
> > 'if a certain value is there, go back to the sheet the user just
> > deactivated
> > 'essentially, the user can't go to any other sheet unless they change
> > the value of a certain cell first
>
> > End Sub
>
> > The code works fine EXCEPT when the user clicks on a sheet with
> > grouped rows and/or columns that have any of those groups collapsed.
> > When that happens, Excel stays on the sheet they just clicked and
> > whatever cell was last activated blinks black and white.
>
> > This seems like a bug to me. *Am I doing something wrong? *Is this a
> > known issue?
>
> > Any help would be appreciated. *If you need more detail, please let me
> > know.
>
> > Thanks.- Hide quoted text -
>
> - Show quoted text -

Actually, I've just discovered that my code works if all groups are
either completely collapsed or completely expanded. If some groups
are collapsed while other groups are expanded, that's when the error
happens.

On Nov 24, 5:44*pm, angelasg <asguill...@gmail.com> wrote:
> First of all, I'm using Excel 2002
>
> I have some code like this:
>
> Private Sub Worksheet_Deactivate()
>
> 'look for a value in a certain cell on the sheet the user just
> deactivated
> 'if a certain value is there, go back to the sheet the user just
> deactivated
> 'essentially, the user can't go to any other sheet unless they change
> the value of a certain cell first
>
> End Sub
>
> The code works fine EXCEPT when the user clicks on a sheet with
> grouped rows and/or columns that have any of those groups collapsed.
> When that happens, Excel stays on the sheet they just clicked and
> whatever cell was last activated blinks black and white.
>
> This seems like a bug to me. *Am I doing something wrong? *Is this a
> known issue?
>
> Any help would be appreciated. *If you need more detail, please let me
> know.
>
> Thanks.