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

bay32ft

New Member
Joined
Apr 4, 2017
Messages
18
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):geek:

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

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,144,341
Messages
5,723,808
Members
422,518
Latest member
quack_quack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top