ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hoe to Get Rid of the Bubbles in Excel (https://www.excelbanter.com/excel-programming/390428-hoe-get-rid-bubbles-excel.html)

PHPBABY3

Hoe to Get Rid of the Bubbles in Excel
 
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?


joel

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?




All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com