Unexplainable Run-time error 1004 from hide/unhide rows code

Hi All,

I have a sheet I am using as a user form that on a button press creates an email with a PDF of the sheet attached to it. During the execution of the macro several rows are hidden and unhidden to set the sheet up for the recipient of the email and then to set the sheet in a 'sent' state for the sender. I deliberately used hide/unhide rows due to the worksheet change event that interferes with the protected state of the sheet.

When the SendButton macro (code attached to sheet1) is called from the send button everything runs perfectly up to the error message 400 with no other explanation. When I step through the the SendButton macro to debug, the error occurs at line 303 - Run-time error '1004': Application-defined or object-defined error.

Line 303:

Please Login or Register  to view this content.

I have no idea why as the worksheet is still in a an unlocked state when the error occurs and works for the previous two hide/unhide row actions. I just cant see why this line should give an error. I've attached the sheet. I'm wondering if I missed something or if this is a glitch with excel 2013.

Any help is greatly appreciated!

Thanks,

I put a break point on that line, run the code it stops at the break point and then I go to the sheet and try to manually hide those rows.
I get a popup error message.
"Cannot shift objects off sheet."
ActiveX object maybe?
I don't know what you have on there, but maybe it's locked or something, modal?

Thanks for the reply skywriter. There are no ActiveX objects on the sheet and the three form control buttons (hidden and unhidden) are not locked. I'm not sure what modal means but I'm happy to explain my sheet further if needed.

This is solved (to a point). I managed to get around the "Cannot shift objects off sheet" error by deleting Rows("22:34") instead of trying to hide them. They were not needed on the sheet after that point anyway.

However, if anyone can explain further why the error occurred, that would be amazing. Thanks again to skywriter for your input.

Regards,