I have devised a worksheet which has been saved as a web page. When the
Worksheet is changed, it automatically updates the web page - this all works
fine.

All print areas are set in Excel to produce the correctly formated print.

Is there a way to insert a control / macro in excel so that when it is
displayed in the web format, you can select the print control (perhaps as a
button) which will then print the worksheet as if it were printing from
within excel with all the correct formatting etc.

Many thanks,

Steve.