View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Hoe to Get Rid of the Bubbles in Excel

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

"PHPBABY3" wrote:

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?