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

Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"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

Sorry the below is a wrong post
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"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

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