At 12:19 PM 12/16/2002, you wrote: >When creating an excel spreadsheet with coldfusion, is there a way to >create what 'freeze panes' in excel does to lock the headers? > >thanks, >seth
It's a part of the workbook's Windows property, in VBA you can access it like this: ThisWorkbook.Windows(1).FreezePanes which is boolean. You can set it to true to freeze panes. I'm not sure how to specify where to freeze them, but I'm sure you can figure it out with a little experimentation. HTH, Sam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
