Mouse Not Working on spreadsheet after running a macro

[Hazelwood]

When some of my macros finish running, I cannot use the mouse on the spreadsheets. I can use the mouse for other applications and can use the excel ribbon - but not on any spreadsheets.

The curser works to move from cell to cell but not the mouse.

My only solution right now is quitting Excel and restarting.

Any suggestions?

 

[philwojo]

I would post the code for one that is causing this issues for people to look at. I am not great with VBA but that would be something I would start with at least.

 

[Hazelwood]

My code is (all variables are defined as Private in the module and all macros work) - just the mouse doesn't work when macros finish

[TABLE="width: 909"]
<tbody>[TR]
[TD]    Call PrepMemberDataForPosting[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD] CurrentMember = 0 and PastMember = 0 - Action Add new member to current[/TD]
[/TR]
[TR]
[TD] CurrentMember = 0 and PastMember = 1 - Action Add past member to current and delete from past[/TD]
[/TR]
[TR]
[TD] CurrentMember = 1 and PastMember = 0 - Action Update Current Member[/TD]
[/TR]
[TR]
[TD] CurrentMember = 1 and PastMember = 1 - Action Update current member and delete from past[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]    If CurrentMember = 0 Then[/TD]
[/TR]
[TR]
[TD]        If PastMember = 0 Then[/TD]
[/TR]
[TR]
[TD]            Sheets("Main Menu").Select[/TD]
[/TR]
[TR]
[TD]            Call PostNewMemberData[/TD]
[/TR]
[TR]
[TD]            Call MemberPayment[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]        ElseIf PastMember = 1 Then[/TD]
[/TR]
[TR]
[TD]            ' Member is a past member so we put them in main file[/TD]
[/TR]
[TR]
[TD]            Call PostNewMemberData[/TD]
[/TR]
[TR]
[TD]            Call DeletePastMember[/TD]
[/TR]
[TR]
[TD]            Call MemberPayment[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]        End If[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]        ElseIf CurrentMember = 1 Then[/TD]
[/TR]
[TR]
[TD]        If PastMember = 0 Then[/TD]
[/TR]
[TR]
[TD]            'Member is a Current Member so we pull it's data[/TD]
[/TR]
[TR]
[TD]            Call UpdateMemberData[/TD]
[/TR]
[TR]
[TD]            Call MemberPayment[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]                   ElseIf PastMember = 1 Then[/TD]
[/TR]
[TR]
[TD]                    ' Member is a Current Member and Past Member so we pull it's data[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]                    Call UpdateMemberData[/TD]
[/TR]
[TR]
[TD]                    Call DeletePastMember[/TD]
[/TR]
[TR]
[TD]                    Call MemberPayment[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]        End If[/TD]
[/TR]
[TR]
[TD]     End If[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]'    Call ClearMemberForm[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]    Sheets("Main Menu").Select[/TD]
[/TR]
[TR]
[TD]    Range("B21").Select[/TD]
[/TR]
[TR]
[TD]    MsgBox "Member Added and Payment Processed"[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]End Sub[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

you are calling a number of procedures, but I have no idea what is contained in them, which maybe where the mouse sleeps

 

[Hazelwood]

Understood on having many procedures. Is there a method for figuring out where my mouse is sleeping? And then for waking it back up?

 

[mole999]

it might be plainly obvious if seen, otherwise know where it fails, and step through with F8 to identify much closer