Trouble with Save as Webpage

[Bernard Liengme]

I am making a webpage from an XLS file. Somehow the process picks up a text
box that I deleted days ago - I cannot find it on the worksheet but it's on
the webpage
Is there a VBA procedure to do a total cleanup?
Many thanks

 

[Ron de Bruin]

Try this

If you want to delete all objects/controls on a worksheet you can do it manual like this:

1. Press F5
2. Click on Special
3. Choose Objects
4. OK
5. Press the Delete button