VBA to save range as a HTML fife

  • Thread starter Thread starter Brian Lahti
  • Start date Start date
B

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
 
Brian

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