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

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

Tom,

I should have mentioned in my original post that I had the user try the same
Excel file on another PC and it worked fine. Likewise, the VBA functionality
used to work for her on her PC up until a few weeks ago. This suggests that
some form of global setting change must have been made to her Excel to
disable VBA functionality. Other than macro security settings (which, if set
too high, can disable VBA), can you think of any other settings that might
have caused her VBA functionality to cease?
--
Regards,
Darren


"Tom Ogilvy" wrote:

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

Installation of VBA was an option in xl2003 and perhaps xl2002.

I would ask what happened a few weeks ago. It is possible that an addin
has been installed that could have an effect.

--
Regards,
Tom Ogilvy


"Darren" wrote in message
...
Tom,

I should have mentioned in my original post that I had the user try the
same
Excel file on another PC and it worked fine. Likewise, the VBA
functionality
used to work for her on her PC up until a few weeks ago. This suggests
that
some form of global setting change must have been made to her Excel to
disable VBA functionality. Other than macro security settings (which, if
set
too high, can disable VBA), can you think of any other settings that might
have caused her VBA functionality to cease?
--
Regards,
Darren


"Tom Ogilvy" wrote:

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