Excel not allowing me to insert a new row

Excel 2010
Click home ribbon insert button displays the message 'Cannot shift objects off sheet'
The options 'display options for this wookbook' 'for objects show: (All)' is selected

The xls has a bit of legacy code in it. In my version of the file i removed all the code but it did not seems to solve the problem. I simply want to inert entire new rows at row 3720.

Note if I remove a few rows from the sheet i can then add a few new rows. Seems to be some type of a limit set.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
Their you go use this fixed your workbook...

Their was problem with your button of your macro file..


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
glenn_rAuthor Commented:
What exactly did you change?
Saurabh Singh TeotiaCommented:
I found out the problem is with you button which was the object..i deleted it and recreated it and rest everything got fixed...Again now their was no specific reason why the button was behaving this manner...
glenn_rAuthor Commented:
That was also my findings. Something must have been corrupt. Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.