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.
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"
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"