Remove Black line above Data which include formulas
 

Hi any help much appreciated.

I am doing an evaluation of a project and as such have lots of sections on
the worksheet which have a question, then the number of people who answered
excellant,poor etc then in the next column a percentage row.

Above 2 of these sections I now have a solid black line which prints. The
black line cannot be selected, it is not a border and prints. When I hover
over it I do not get any options.

How do I get rid of it?

Many thanks

Remove Black line above Data which include formulas
 

Maybe...

Show the control toolbox toolbar
(via View|toolbars|control toolbox)

Click on the design mode icon.

Try selecting the object and hitting the delete key on the keyboard.

If you don't have any objects you want to keep, you can delete them via:

Edit|goto|special|objects
and hit the delete key

When you're done, turn off the design mode (click that button again)

Apples wrote:

Hi any help much appreciated.

I am doing an evaluation of a project and as such have lots of sections on
the worksheet which have a question, then the number of people who answered
excellant,poor etc then in the next column a percentage row.

Above 2 of these sections I now have a solid black line which prints. The
black line cannot be selected, it is not a border and prints. When I hover
over it I do not get any options.

How do I get rid of it?

Many thanks

--

Dave Peterson

Remove Black line above Data which include formulas
 

Cheers Dave

That has took me one step further

When I enter design mode then goto-special-objects I can delete but it
deletes all my graphs as well which I can't have.

I have learnt that these black lines are actually minimized graphs from a
previous evaluation I have done. I have a master and just alter it each time.

When I do goto-special-objects I can extend the lines to get to the graphs
but then not delete them when they are maximised. When I tried cutting them
the PC crashed.

Cheers
"Dave Peterson" wrote:

Maybe...

Show the control toolbox toolbar
(via View|toolbars|control toolbox)

Click on the design mode icon.

Try selecting the object and hitting the delete key on the keyboard.

If you don't have any objects you want to keep, you can delete them via:

Edit|goto|special|objects
and hit the delete key

When you're done, turn off the design mode (click that button again)

Apples wrote:

Hi any help much appreciated.

I am doing an evaluation of a project and as such have lots of sections on
the worksheet which have a question, then the number of people who answered
excellant,poor etc then in the next column a percentage row.

Above 2 of these sections I now have a solid black line which prints. The
black line cannot be selected, it is not a border and prints. When I hover
over it I do not get any options.

How do I get rid of it?

Many thanks

--

Dave Peterson

Remove Black line above Data which include formulas
 

Did you try selecting the individual chart (that black line) when you were in
design mode?

If not, then try that.

Just a guess about the crashing--make sure the zoom factor is set to 100%.

Since you know they're charts, maybe you could find the names of the ones you
want to keep and not delete them. Just right click on each chart and take note
of the name that shows up in the Namebox (to the left of the formulabar).

Or you could try this macro:

Option Explicit
Sub testme()
Dim ChtObj As ChartObject
Dim resp As Long

For Each ChtObj In ActiveSheet.ChartObjects
resp = MsgBox(Prompt:="Delete this one named: " & vbLf _
& ChtObj.Name & vbLf _
& "at: " & ChtObj.TopLeftCell.Address(0, 0) _
& "-" & ChtObj.BottomRightCell.Address(0, 0), _
Buttons:=vbYesNo)
If resp = vbNo Then
'keep it
Else
ChtObj.Delete
End If
Next ChtObj

End Sub

Save before you try it.

Apples wrote:

Cheers Dave

That has took me one step further

When I enter design mode then goto-special-objects I can delete but it
deletes all my graphs as well which I can't have.

I have learnt that these black lines are actually minimized graphs from a
previous evaluation I have done. I have a master and just alter it each time.

When I do goto-special-objects I can extend the lines to get to the graphs
but then not delete them when they are maximised. When I tried cutting them
the PC crashed.

Cheers
"Dave Peterson" wrote:

Maybe...

Show the control toolbox toolbar
(via View|toolbars|control toolbox)

Click on the design mode icon.

Try selecting the object and hitting the delete key on the keyboard.

If you don't have any objects you want to keep, you can delete them via:

Edit|goto|special|objects
and hit the delete key

When you're done, turn off the design mode (click that button again)

Apples wrote:

Hi any help much appreciated.

I am doing an evaluation of a project and as such have lots of sections on
the worksheet which have a question, then the number of people who answered
excellant,poor etc then in the next column a percentage row.

Above 2 of these sections I now have a solid black line which prints. The
black line cannot be selected, it is not a border and prints. When I hover
over it I do not get any options.

How do I get rid of it?

Many thanks

--

Dave Peterson


--

Dave Peterson