Hidden Objects, Links, unselectable and undeleteable

TonyHavard

New Member
Joined
Sep 3, 2020
Messages
7
Office Version
  1. 2019
Platform
  1. Windows
Good morning everyone,
I run windows 10, Excel 2019. I have an excel worksheet with approximately 16 charts shown in
this sheet comprised of data within the workbook. However, I have one sheet that shows a chart,
which I did not create, and this chart is only visible in print preview, and if I attempt to change the
background color, the chart can be viewed in a preview of the color change only. Once the color
actually changes, it is gone again. There is no protection on the sheet, the object is not hidden, I
have broken any links associated (as I am aware). Would like to see if anyone has any knowledge of
this situation from previous experience. I do not mind sharing the sheet if someone would like
to take a look. I am not a newbie to excel, just to this forum. Thanks in advance for any suggestions.

Respectfully,
Tony
 

Attachments

  • Chart not showing graph.PNG
    Chart not showing graph.PNG
    129.9 KB · Views: 2
  • Chart Showing graph.jpg
    Chart Showing graph.jpg
    153.5 KB · Views: 2

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,809
Office Version
  1. 365
Platform
  1. Windows
For info the two charts are chart 4 & Chart 5
If you select any chart, then on the Format tab select "Selection Pane", and you can bring up the charts.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

TonyHavard

New Member
Joined
Sep 3, 2020
Messages
7
Office Version
  1. 2019
Platform
  1. Windows
Perfect. The VBA code selected them and I was able to delete them. Thank you very much Fluff!
Problem solved. For reference, what occurs to make these particular items undetectable unless
viewed in print preview as happened?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,809
Office Version
  1. 365
Platform
  1. Windows
The property of both had been changed to "Don't move or size with cells"
Although I'm not sure why that would hide them.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,809
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,073
Messages
5,639,920
Members
417,119
Latest member
adityaj252

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