View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default Excel file format.

i am using the code below, i am coming in after this was already built. it
appears that fileformat 16 will not let me password protect the sheet. is
there a way around this? what is file format 16?
i tried oBackLog.SaveAs(cblfile,16,12345) but the sheet was not protected.
so im lost.

osheet.protect("12345")
if File(Cblfile)
Erase(Cblfile)
endif

if nform = 2
oBackLog.SaveAs(cblfile,16)
endif
if nform = 5
oBackLog.SaveAs(cblfile,43,)
endif
if nform = 0
oBackLog.SaveAs(cblfile,-4143)
endif