I have built a fairly simple spreadsheet where you copy/paste data from a website. With a macro, I copy down some formulas to clean up the pasted data and then the user copies from one of the "clean" columns to another tool. Works fine.
However, apparently everytime you paste from the website, it is pasting in some sort of hidden HTLM form along with the data. You only see them when you go into Design Mode. When you select one it shows:
=EMBED("Forms.HTML:Hidden.1","")
in the formula bar. After copying/pasting several times, I ended up with over 1000 of these little hidden forms and eventually my macro buttons stopped pulling their respective code and when I ran the macro from the VB editor, I got an error message essentially saying it was not recognizing the Sheet anymore. Even stranger, if I went into Design Mode again and double-clicked on my command buttons, it would not show any code for them on that sheet in the VB Editor. Again, it would not recognize the sheet. (For any retailers out there, I am pasting from the QRS Keystone website).
I eventually had to rebuild my file and as long as I do not copy too many of these hidden forms, the process works fine. Does anyone know anything about these forms? Is there a way to select and delete them all?
However, apparently everytime you paste from the website, it is pasting in some sort of hidden HTLM form along with the data. You only see them when you go into Design Mode. When you select one it shows:
=EMBED("Forms.HTML:Hidden.1","")
in the formula bar. After copying/pasting several times, I ended up with over 1000 of these little hidden forms and eventually my macro buttons stopped pulling their respective code and when I ran the macro from the VB editor, I got an error message essentially saying it was not recognizing the Sheet anymore. Even stranger, if I went into Design Mode again and double-clicked on my command buttons, it would not show any code for them on that sheet in the VB Editor. Again, it would not recognize the sheet. (For any retailers out there, I am pasting from the QRS Keystone website).
I eventually had to rebuild my file and as long as I do not copy too many of these hidden forms, the process works fine. Does anyone know anything about these forms? Is there a way to select and delete them all?