Hiding colums when saving as html

[Big-dog1965]

I have a speed sheet that I update and save as html on a weekly bases. It has
several colums that are not used all the time. I would like to hide the
unused colums then save as html, but Ive tried the hide and when I save it it
only shows the last 2 colums on the sheet. the colums I want to hide are like
F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB.
When I open in excel I dont want the colums hidden just hidden in the saved
html file.
How do I make this happen.

 

[Dave Peterson]

In xl2003 menus, you can make a couple of custom views.

With all the columns showing:
View|Custom Views|add a new view named Normal

Hide the columns you want
View|Custom Views|add a new view named ForHTMLSave

Then just show/hide the view you want when you want.

 

[Big-dog1965]

how do I do the custom view for whole work book or do I have to create custom
views for each sheet

 

[Dave Peterson]

Seems like a pretty easy thing to test.

Use a test workbook if you don't want to take a chance on your real workbook.

 

[Big-dog1965]

Thanks got it working

Seems like a pretty easy thing to test.

Use a test workbook if you don't want to take a chance on your real workbook.