DRE,

The easy way is to "record" a macro to do exactly what you want.
Tools/Macro/Record New Macro
When done, use a CommandButton from the "Forms" menu
View/Toolbars/Forms
When you drag the button to your worksheet, you'll be promted to
assign a macro to it. Assign the one you just recorded.
Every time the user presses the button, it'll do exactly what you
recorded in the macro.

John

DRE wrote:

I need to have a button in an execl file that when clicked
will save the modifications made and then save the file as
an html file on a server to be viewed as a web page. I
know that all you have to do is click "save as html" but
we don't want the users to have to learn to do that.

Thanks in advance for any help.