Command buttons no longer working

Hi all,

I recently got my big workbook working perfectly. I realised that I didn't need a couple of the command buttons I was using so I deleted them. Now none of them work. Originally I had 28 buttons each of which called an almost identical macro. I can not see why this would occur. Below is the code for 2 of the buttons. Commandbutton1 and 14 were deleted. it comes up with this error.

"Run-time error '1004':

Unable to get the OLEObjects property of the Worksheet class"

The bold line is what is highlighted for the error.

Please Login or Register  to view this content.

If you don't have 28 buttons, you shouldn't be looping from 1 to 28 anymore.

If you deleted 1 and 14 you need to skip processing those. Either loop through all the OLEObjects and, if necessary, test for a CommandButton (assuming all buttons should be processed), or add an if clause like:

Please Login or Register  to view this content.