Can't Close Excel

[Pullingmyhairout]

Good Evening,

Hoping someone can assist me. I have put putting together an excel spread sheet and have been using some VBA code. I am a novice amongst novices and have gathered all the code from around the web and it does exactly as i need and works perfectly.

I used excel 2010 to create my spreadsheet and everything works fine...the issue is if I open the file using excel 2013 (haven't tried 2016) I can not use the x to close the program even if i disable the vba code that hides the ribbon. The only time i'm able to use the X to close out of the program is if i navigate to the very first sheet.

All help is appreciated. thank you.

A link to my excel file is below

https://www.dropbox.com/s/2hlfwefksom3be9/Book8.7.xlsm?dl=0

 

[Pullingmyhairout]

Upon opening your workbook, I can click the X to close it in both 2013 and 2016.

Yes upon initially opening the workbook if you do not navigate to another sheet you can close it. Once you navigate to another sheet the ability to close the workbook no longer works

 

[Michael M]

Are any of your sheets protected.....I'm guessing that the worksheet_activate code is where the problem lies.....try commenting out that code and see what happens

 

[footoo]

This might help :
6 best fixes for hair loss

 

[RoryA]

Add this to a normal module:

Sub ResetScrollBars()
    With ActiveWindow
        .DisplayHorizontalScrollBar = True
        .DisplayVerticalScrollBar = True
    End With

End Sub

and then change the Worksheet_Deactivate code of the startup sheet to this:

Private Sub Worksheet_Deactivate()
'On worksheet open turn off scroll bars.
Application.OnTime Now(), "ResetScrollBars"
End Sub