Creating excell worksheets with protection using VB

[hoose]

hi everyone, i'm not quite sure if this is the best forum to present this question, but here it goes...

I'm exporting data files from an access database into excell 97 worksheets. When access creates the worksheets, I want them to be automatically protected.

I'm not really sure where to start. Can anyone help me out?

Thanks in advance.

dan

 

[SkipVought]

Hi,

After all the changes and formatting has been done on the worksheet...

NewWorksheet.Protect

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com