Deleting leftover sub after deleting the Command button

[whr4th]

This should be easier than I am making it. I have a spreadsheet in one workbook that has a button that activates a macro that copies the tab to a new workbook and saves it. The new workbook only has the one tab in it and, to clean up the sheet, I deleted the leftover button (since it won't work anyway). But, when you open the new file, you still get the Disable/Enable macro pop-up box.

There is no Module attached to the new worksheet. All that is left is the following code which is embedded under the Microsoft Excel Objects under the sheet name:
Private Sub CommandButton1_Click()
Export_Sheet
End Sub

I have verfied that by manually deleting the offending code, upon reopening the spreadsheet, I no longer get the pop-up box.

I am trying to deliver the new spreadsheet to the end users without the command buttons (which I have done) and without the starting Disable/Enable pop-up.

Thoughts anyone?

 

[Norie]

I assume you have taken the button from the Control Toolbox toolbar?

Try using one from the Forms toolbar instead.

 

[whr4th]

That worked perfectly. I knew it was simpler than I was making it.

Thanks!