Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the code below which deletes "Objects" in my sheet, my problem is that it deletes a cell in Column A and moves all cells up one space, I don't know why this is occurring
When I try and select "Objects" within Find-Go to Special-Objects, it says there is none to be found and that is before I run the code below Hope someone can advise Thanks Sub ClearMacroButtons() Application.ScreenUpdating = False Sheets("Figures").Visible = True Sheets("Figures").Select ActiveSheet.Unprotect Password:="1234" ActiveSheet.DrawingObjects.Select Selection.Delete Range("A1").Select ActiveSheet.Protect Password:="1234" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel2007 objects drawn on charts move in print preview | Charts and Charting in Excel | |||
How does one select multiple drawn objects in Excel 2007? | Excel Discussion (Misc queries) | |||
Using Macros to manipulate drawn objects | Excel Discussion (Misc queries) | |||
text boxes drawn objects do not appear on chart | Charts and Charting in Excel | |||
Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel |