View Single Post
  #1   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bernard Liengme" wrote in message ...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email