VBA FEatures Not Working

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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?

 

[Tom Ogilvy]

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.