Protecting a sheet and keeping grouping

T

TommyD

Hi all, attached is template I am using for a VB program. I need th
grouping function and filter function to remain, but need to lock dow
the formatting on the doc. The VB program open and populates populate
about 80 of these templates every time it runs, so I really can't d
this on a one by one basis. The filter function is working, but no luc
at all with the grouping. I would like to be able to password protec
the file as well. I have tried little snip-its of code hear and there
but nothing seems to work. Help

+-------------------------------------------------------------------
|Filename: FRED_111.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=115
+-------------------------------------------------------------------
 
Top