D
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!!
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!!