My first suspician is that you have code that makes these changes and for
some unexpected reason, this user is causing that code to run. The challenge
would be to determine what causes the code to run.

--
Regards,
Tom Ogilvy


"Darren" wrote:

I designed an Excel spreadsheet with a range of VBA features, which include
check boxes and drop-down lists.

Another user has complained that when they tick a check box or select an
option from a drop-down list, their choice is not "sticking". In other words,
the tick they place in the check box goes away shortly thereafter, and
similarly, the choice they make from the drop-down list gets superceded by
the default from that drop-down list.

I have checked with the user that the macro security settings are low. The
VBA features are thus active, but are not retaining or reflecting the actions
that the user takes.

I was wondering whether anyone could shed some light on what might be
causing this.

--
Regards,
Darren