LinkBack URL
About LinkBacks
This is driving me crazyHow do I remove the empty, unused "Chart3" project form the list below?
Image1.jpg
This is driving me crazy
Image1.jpg
Hi Jeff,
Look at your sheet tabs (not in VBA) and delete the tab/sheet that is the Chart Sheet.
Sorry if that doesn't work. Stuff seems so simple when you know how and hard when you/we don't...
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Assuming you want the actual chart sheet in your workbook you will not be able to remove it from the project view.
Chart objects, like sheet objects, have events. The object is automatically included in the properties window. But there will be no actual code unless you open and edit the object.
Thanks for the replies. Unfortunately life isn't that easy, at least for me
This spread sheet does not have a Chart3 or even a Chart2.
In the beginning, I had a workbook that with the help of my VBA would build either of two charts depending on which button was clicked on a control page.
I wanted to separate the two charts into two workbooks. I made two copies of the original (the one that could do both charts), and modified each to only create one chart, but both still appear under VBA projects.
There is now only one chart per workbook. There are no tabs for the one that no longer exists, but it still appears in the VBA project list.
Look at the sheet properties in the VBE properties pane and check if VISIBLE is set to "2 - xlSheetVeryHidden". If so, reset to Visible, then...
Ben Van Johnson
I don't know if I looked in the right place. There are 4 sheets including the one chart that I want. I clicked on Developer - Properties for each one. They all show xlvisable.
Thanks for the tip, Ben! Always wonder where to locate the veryhidden sheets.Originally Posted by protonLeah
Look in: Developer > Visual Basic > View > Properties Window.
That worked!
I tired it on the nonexistent Chart2, but "Visible" is not in the Properties list.
Image1.jpg
Last edited by JeffLeites; 12-04-2022 at 11:21 AM.
Your attachment is not valid.
Jeff look at the picture you posted.
Where it shows (Name) in your picture the box to the right shows the name of what you are viewing the properties of.
Your picture shows ThisWorkbook next to name.
I didn't notice that when I posted.
All of the other projects show the project name next to "Name" in the properties window (like the one below). Chart2 shows the Workbook properties. Why is that?
Last edited by JeffLeites; 12-04-2022 at 10:20 PM.
Again unable to open your attachment. Please see the yellow banner at the top on how to attach workbook.
It's not a workbook, it's a picture of the properties window. I don't know why your are having a problem, they all appear in line wherever I've posted them in this thread.
I just noticed that I did have an attachment in one post. It was unintentional, I only meant to post a picture of the properties. I deleted the attachment.
Last edited by JeffLeites; 12-04-2022 at 10:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks