Nevermind, some days I'm just not thinking clearly.

I embedded the "ActiveWorkbook.PublishObjects" inside of DeBruin's original
macro.
So it saves the worksheet as html after populating it.


"Ronio" wrote:

I was able to use Ron DeBruin's excellent macro to take a master sheet and
break it into seperate sheets based on a value in the first column.

Now I need a macro that will save every worksheet to HTML with the 'add
interactivity' box checked.

Can somebody point me to an existing macro?

TIA,
Ron