Button and shapes disappearing until "an action" is done on the sheet

[bay32ft]

Hello,

I have Excel plus 2016 installed if that matters.

I have an Excel file with some code that runs smoothly with buttons that print PDF, shapes with text and cells that change other cell values depending on their own values. Basic.

But when I do something that will run a piece of code, for exemple the following that hides rows in the sheet Page 3 when "Hide' is the value of a selected cell.

Private Sub Worksheet_Change(ByVal Target As Range)


If Target.CountLarge > 1 Then Exit Sub
If Not Intersect(Target, Range("F46:F51")) Is Nothing Then
Sheets("Page 3").Rows(Target.Row - 40).Hidden = Target.Value = "Hide"

The buttons and shapes disapear and I need to scroll or change sheet and come back to make them reappear.

If I had to guess I would say it is maybe an hardware problem but as I work on a computer given by my company I cannot tweak anything (software and hardware)

I am trying to make my Excel sheet "Boomer proof"

 

[vw412]

This is a problem that needs to be duplicated on other machines to find solution. I recommend you upload your workbook to a file sharing service like Dropbox or something similiar then post a link to it so we can actually try to duplicate problem on our machine and figure the cause and solution.