How do I locate a fixed object in excel?

G

Guest

I am attempting to hide columns in excel. At a certain point I get an error
message which states "Cannot shift objects off sheet." I don't believe that
I have any objects in my sheet. For fun I tried to insert a column and I get
an error message that "Fixed Objects will move". I would like to find the
object so that I can delete it.
 
C

Chip Pearson

Try running the following macro:

Sub AA()
Dim SH As Shape
Dim OLEObj As OLEObject

For Each SH In ActiveSheet.Shapes
Debug.Print "SHAPE: ", SH.Name, SH.TopLeftCell.Address
Next SH
For Each OLEObj In ActiveSheet.OLEObjects
Debug.Print "OBJECT: ", OLEObj.Name,
OLEObj.TopLeftCell.Address
Next OLEObj
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ricia.robertson" <[email protected]>
wrote in message
news:[email protected]...
 

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

'Cannot shift objects off sheet' error message (group/outline) 2
hiding columns no success 1
cannotshiftobjectsoffsheet appears when I insert columns , why? 2
inserting rows in spreadsheet 1
How do I copy or move a worksheet to another workbook? 6
what causes a "Fixed objects will move" warning & how do you get . 0
"Cannot shift objects off sheet" error when trying to hide a colum 2
"fixed object" warning message 1

Top