When I save-As Web page there are two options nameley Publish or save.

Publish only saves the sheet I am on at the time of saving but does allow
'Autorefresh every time file is closed'.

Save does save all tabs which are displayed as such as a Web page. I would
like the best of both worlds, saving the spreadsheet with all tabs but with
the refresh option.

Has anyone any ideas.

Cheers Dave