I have Some Sort of Macro/Worksheet Corruption Problem :-(

[dim]

Hi folks, long time no talk! I've had terrible trouble since the start of
2008. I can log into MS Office Online, but couldn't post any
questions...until now...argh! ;-)

Anyway...I have a MAJOR problem! :-( MS Excel 2002. Win XP SP2.

I have a number of worksheets in my workbook.
One sheet is called 'CurrentEmployees' and one is called 'VehicleSettings'.

On the CurrentEmployees sheet there are a number of buttons each attached to
a Macro. One of these buttons is use to edit employee data and it's attached
to the macro 'EditEmpTest'

On the VehicleSettings Sheet there are a number of buttons attached to their
own macros. Here's my problem:

After I manually LOCK (Protect) my VehicleSettings worksheet, the mouse
pointer changes from the usual arrow type to a hand pointer, and if I
'left-click' it anywhere it runs the EditEmpTest macro which has nothing to
do with this sheet. :-(

Other info that may be relevant:

1) When I unlock the VehicleSettings worksheet the problem disappears.

2) If I hold the Ctrl or Shift key, the pointer changes back to the standard
arrow, but if I left-click it group selects as per normal while holding these
keys. If I let go of the key, the hand (Of misery?) returns.

3) While the pointer is a hand, if I click on an actual button on the
VehicleSettings sheet, the buttons correct macro is executed, not the random
macro that has nothing to do with this sheet.

Please Help!!

 

[dim]

Hi folks,

I still don't know what caused this, but would like to for future reference
if possible?

....but I've managed to remove the problem by re-creating the relevant
worksheets, and deleteing the originals, then re-naming the recreated ones
with the name of the original.

I didn't copy/paste the entire original worksheet across to the new one
because this reproduced the problem, instead I only selected the rows I
needed and copied/pasted these across. For some reason this worked. Its a
pain having to resize all the columns, but luckily I noticed this now, and
only have to redo 6 out of an eventual 78 worksheets.

 

[JLGWhiz]

I was hoping you would solve the problem and let us know what the cause was.
Your description sounded like a possible mouse-over call, or possibly an
induced worksheet change procedure, but I wouldn't know how to tell you where
to start looking, except everywhere code can be entered. Macros don't just
run of their own accord. They have to be triggered by some event, whether by
keystroke, mouse or change of a value.

 

[dim]

Thanks JLG.....this one was very strange. It was being triggered by an action
(Left mouse click) but unfortunately it seemed my entire screen was now the
button !! I don't have any on-action commands written into this project yet,
although that wouldn't explain the mouse pointer permanently changing to the
selection hand when the sheet is locked....if I have time during the week
I'll try to recreate it and report back. L8rs.