Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
try this code
but be advised, it deletes any Ole object inserted in the sheet, it doesn't matter wath type is it here's the code Private Sub deleteobjects() Dim s As Sheet1 Set s = ActiveSheet Dim olObj As OLEObject With s For Each olObj In .OLEObjects ..OLEObjects(.OLEObjects.Count).Delete Next End With set s= nothing set OlObj=nothing End Sub -- hope this works! --- zz [MX] cuasi-musico,semi-poeta y loco "come_mon_come_mon!" wrote in message ups.com... Gary''s Student ¼g¹D¡G Using VBA: Cells.Hyperlinks.Delete ActiveSheet.Pictures.Delete -- Gary's Student YEAH !!! IT WORKS WITH URL LINKS !!!!! NOW ONLY THE CHECK BOXES WERE LEFT REMAINED UNCLEARED :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Insert Page numbers without Footer | Excel Discussion (Misc queries) | |||
Page Numbering | Charts and Charting in Excel | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
page break preview | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |