Protected Sheet crash when use the tab key

[Sergio]

I have googled this question in many different ways and I can not find an answer. Here is my problem: I created a file with formulas and macros and of course the worksheet is passwords protected. I can navigate on the file using the arrows and the mouse. I thought that everything was good until I shared the file in the company and half of the team is complaining that when they use the TAB KEY to move from cell to cell the excel file crash.
I know the easy answer is STOP using the tab key... but know I need to solve this problem without unprotecting the sheet....
Does anyone knows a way around? the two post I found in this site do not give an answer.
Thanks
Alex

 

[Candyman8019]

do you have any worksheet_selectionchange code that may be causing issues? It would help to understand exactly what code you have running in vba.

 

[Sergio]

No Major coding... couple of change color code macros
Sub cambiocolor1()

Dim sidetop As Shape
If ActiveSheet.Shapes("sidetop").Fill.ForeColor.RGB = RGB(165, 165, 165) Then
ActiveSheet.Shapes("sidetop").Fill.ForeColor.RGB = RGB(255, 153, 51)
ElseIf ActiveSheet.Shapes("sidetop").Fill.ForeColor.RGB = RGB(255, 153, 51) Then
ActiveSheet.Shapes("sidetop").Fill.ForeColor.RGB = RGB(165, 165, 165)
End If
End Sub

Some hide and unhide rows and a button to go back to A1

Sub home()
Sheets(1).Select
ActiveSheet.Range("A1").Select
End Sub
Sub vba_hide_row_columns()
'hide the row 1
Range("1:11").EntireRow.Hidden = True
End Sub

Sub vba_hide_row_columns2()
'unhide the row 1
Range("1:11").EntireRow.Hidden = False
End Sub
Sub PopUpInstructions()
MsgBox (" ' - ' Hides the rows for title box upto row #11." & Chr(13) & Chr(13) & "' + ' Shows the rows for title box upto row #11." & Chr(13) & Chr(13))

End Sub

When I unprotect the sheet I have no problem moving around using the tab key.
I need to keep the file protected because formulas and conditional formatting

 

[Candyman8019]

Is there a specific cell or range that cause the app to crash...or is it tabbing anywhere in the sheet?

 

[Sergio]

Is there a specific cell or range that cause the app to crash...or is it tabbing anywhere in the sheet?

anywhere... i move the mouse to a cell... write something and then tab key.... and crash..... even if you click on a cell and then just hit the tab key... crash

 

[Candyman8019]

do you have any conditional formatting with formulas that may be causing issue?

 

[Sergio]

no really. I see on google that this is very common issue with protected sheet but i dont see any solution

 

[Candyman8019]

Have you tried creating a fresh workbook and copying the tabs over?

 

[Sergio]

i created a new file for testing... and as soon as you protect the sheet tab doesn't work

 

[Candyman8019]

When you created your blank sheet, you need to set some cells as 'unlocked' in properties before you protect the sheet.

Alternatively, if a fresh workbook doesn't work...
Are you able to try that sheet on a non-domain computer? I'm leaning to a possible excel issue needing reinstall or possibly something security related.