VBA to save range as a HTML fife

[Brian Lahti]

It is a simple matter to manually save any part of a
spreadsheet at a .htm file. When I macro record the
process the code doesn't work in a command button.
Does anyone know of a VBA code to perform this?

Thanks

Brian

 

[Dick Kusleika]

Brian

If you are using a command button from the Control Toolbox, see if changing
the TakeFocusOnClick property makes a difference.