Rocco42

Windows Excel 2010.

Mike, I would NEVER hide a tab... This was the first version for this year and in fact i downloaded again and went straight to the compiler, gave me the same error. i also just pulled up ccdb_football_2011_2.2 and ran the compiler, just to see if my system was interferring with the code. Ran fine.

i am getting a "Compile error in hidden module: Module1" error when i run the compile cheat sheets. Everything else works - Check for Update, Update Projections and Copy League Settings. I have used the buddy for years, and used it on this computer last year, so can't understand why the issue. Any security setting in the module? Any help is appreciated.

All, First off, compiler is the best tool i have found out there. Sophisticated and powerful, its incredibly easy to use. I am throwing out here a small tweak. I add in projections from others as well, and had an issue with the mixing when one of the other sites did not project a player that mike did. It seemed to me be be tedious to go through and reset each one. So, 1) in Setup, set each of the allocation keys accordingly: 10. Average all 3 sites 33% 0% 0% 0% 0% 33% 33% 11. Custom % allocation 50% 50% 12. Custom % allocation 50% 50% 13. Custom % allocation 50% 50% Then, in the L column of each projection sheet, copy in the following formula: =IF(V130>0,IF(AA130>0,IF(AB130>0,10,11),IF(AB130>0,12,1)),IF(AA130>0,IF(AB130>0,13,8),IF(AB130>0,9,1))) The only catch is this: everytime you update the compiler, the L column is hard coded and the formula is lost. What i do is leave a copy of this formula at the bottom of the lists in the l column, and then re-copy before I run the cheatsheet compiler. Have fun.