I'm trying to create a script that saves a sheet in Excel
as an HTML file using VB. In Excel, the "A" column is
frozen because it contains names, the other columns ("B"
though "AI") contain the data that corrisponds to the name
in the "A" column. Since there more columns that contain
data then will fit on the screen, I need to keep the "A"
column frozen in the HTML file (so when you scroll the
side of the HTML file the stuff that was in "A" colum
stays still, similar to the way it works in Excel when you
freeze a column). I also want to keep the web page
static, so people can't edit anything.

Is there way to do this? This is what I have right now.

ActiveWorkbook.PublishObjects.Add _
SourceType:=xlSourceRange, _
Filename:="C:\bm\www\Win2k-1CPU\data.htm", _
Sheet:="Data", _
Source:="A1:AI510", _
HtmlType:=xlHtmlStatic, _
Title:="RawData"

Thanks