I am using Excel 2007 and I have a question when using Excel to save worksheets and charts to a HTML (.htm or .html) webpage via VBA.
I have a worksheet that has some command buttons on it. They are set to not print, but when I save this worksheet as a HTML file, these command buttons are embedded in the HTML code (i.e., they appear). I looked at the HTML source code that the PublishObjects method produced and I found that the command buttons are being converted into .gif files. This is a little annoying because it looks like you can click on these buttons to do something, when in fact, they are just inert images of the buttons themselves.
Is there a way that I can exclude shapes from appearing in the HTML output that Excel's PublishObjects method produces?
I have a worksheet that has some command buttons on it. They are set to not print, but when I save this worksheet as a HTML file, these command buttons are embedded in the HTML code (i.e., they appear). I looked at the HTML source code that the PublishObjects method produced and I found that the command buttons are being converted into .gif files. This is a little annoying because it looks like you can click on these buttons to do something, when in fact, they are just inert images of the buttons themselves.
Is there a way that I can exclude shapes from appearing in the HTML output that Excel's PublishObjects method produces?
