Hoe to Get Rid of the Bubbles in Excel

  • Thread starter Thread starter PHPBABY3
  • Start date Start date
P

PHPBABY3

Someone sent me an excel spreadsheet but there are bubbles covering
random portions and it can't be read. The help menu only contains
undefined jargon. How do I fix it?
 
Not sure what the buble really are. This will get rid of all shapes. May
get rid of things you need.


Sub Macro1()
'
' Macro1 Macro

'

'
For Each Shape In ActiveSheet.Shapes

shape.delete
Next Shape
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

annoying bubbles and info boxes 3
bubble Chart bubblesize problem in VBA 3
Bubbles Screensaver, Registry Value, Help Please. 6
How do you get rid of those help bubbles 2
missing information bubble 2
How to get rid of Start Menu Bubble 8
How to get rid of shift alt ctrl bubbles on screen 1
Truncation of string problem 3

Back
Top