ࡱ> ^ZCompObj)aVBFrame$PROJECTwmtPROJECT 2610 ClientLeft = 45 ClientTop = 330 ClientWidth = 4620 StartUpPosition = 1 'CenterOwner TypeInfoVer = 39 End Sheet1Sheet1ThisWorkbookThisWorkbookModule1Module1UserForm1UserForm1ID="{00000000-0000-0000-0000-000000000000}" Document=Sheet1/&H00000000 Document=ThisWorkbook/&H00000000 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} Module=Module1 BaseClass=UserForm1   !"#$%&'(*+,-./0123456789:;=>?ACDEFGHIJKLMNOPQRSTVWXY[]^_`abcdefghijklmnopqrstuwxyz{|}~ \pJohn Walkenbach Ba= ThisWorkbook=,L;"<X@"1hArial1hArial1hArial1hArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)#,##0\ "kr";\-#,##0\ "kr"##,##0\ "kr";[Red]\-#,##0\ "kr"$#,##0.00\ "kr";\-#,##0.00\ "kr")$#,##0.00\ "kr";[Red]\-#,##0.00\ "kr">9_-* #,##0\ "kr"_-;\-* #,##0\ "kr"_-;_-* "-"\ "kr"_-;_-@_->9_-* #,##0\ _k_r_-;\-* #,##0\ _k_r_-;_-* "-"\ _k_r_-;_-@_-FA_-* #,##0.00\ "kr"_-;\-* #,##0.00\ "kr"_-;_-* "-"??\ "kr"_-;_-@_-FA_-* #,##0.00\ _k_r_-;\-* #,##0.00\ _k_r_-;_-* "-"??\ _k_r_-;_-@_-                + ) , *  `Sheet1StartDateReport8ZR3  @@  cc    dMbP?_*+%"??U(  x  6CC@],@`ҏ9 $< Button 1<1>@7 Sheet1 LzB@#<H3K؄AȽח FH K E&xH K E&H3K؄AȽחME(SLSS6"Sheet1 )__SRP_8 <__SRP_9@BThisWorkbook BN0{00020820-0000-0000-C000-000000000046}(%H(p % %pxH@HH8&CT$*\Rffff*3G432689d94 xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 9.a..4..`rU @nDrBF#<;RׯF"+GFxCOk޻zxxCOk޻zܰ;RׯF"+GME(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%Hh % %8p@@TT8&CT$*\Rffff*05431c44e44 xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 rU (#4q9__SRP_6 U0__SRP_7ZBModule1\{UserForm1?I`rU @n BГxMEhHhH :p "H0p" "HPX"h  ">   ]$Power Utility Pak]$Data Validation Report0A@" $G|j $$& WorksheetG|j (B@*oXp,HA1pup6.xla$.%0%2UtilityG|j, B@B$ofAttribute VB_Name = "Module1" Public Const PUPNAME As S ngPower Utilit y Pak jAPjData Validation Report: Sub A() CheckAddInIf ActiveSheet Is NothiThen E0xit S,Type(5) <> "Works "" UserForm1.Show End+ဒriva]OXOBrror GoTo Clo0seMeG:books("pup6.xla")1es(1).Range("A1"^)P+:+Thhis,. WB0* pHd ValidReport8@ = t  &C(T J< rstdole>stdole f%\*\HelpFile="" Name="ValidReport" HelpContextID="0" VersionCompatible32="393222000" CMG="F9FB55A359A359A75DA75D" DPB="6E6CC26D4297AAB4AAB4554CABB4A959D8A3383207E86B2AB1BAD414D10E9A6259F0F086F5A131" GC="E3E14FF8C5F9C5F9C5" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Sheet1=0, 0, 0, 0, C ThisWorkbook=0, 0, 0, 0, C Module1=0, 0, 0, 0, C UserForm1=0, 0, 0, 0, C, 66, 87, 1198, 713, C $J N(Dko ]`]]]]] Check for protected sheets L $!bThe active sheet is protected. f f?A Formula Report cannot be generated for a protected worksheet. h A@d A@r| |kd'^ \ j!l{l \!b ^ $n  \! f'^k  \ ^->A Formula Report cannot be generated for protected worksheets. f9The activeworkbook contains one or more protected sheets: f f ^ fContinue anyway?'^ ^ p r $d'` ` t A@r`|kkk j.Rw@@ $.V( Adjust settings to maximize the speed, v(x v!|$z A v!~!'8 v!~(k@ v!':,  v( ,% Create new workbook for the report8 v!'X8 L v(, .B@T@, X v( , VA. Run the report,dx R!l! v(, .B@, X v(, Z R!l!J Z R%l ZA? Run the report, Z,k Rename the sheetsT , Z j!l! Z R%l! Z$l( Z l!G V!$l(j  Save the user settings   obActiveOnly L!DA@l   obAllSheets N!DA@AA A@r0wvo ]]]]A]0H2]`]x 4 B(DCt Working on ! $nSheet   of  j!l!' (A@k  j%l.  !'xxx  ( Check for protected sheet !b  ! in  !!( is protected. Report was not generated. , %!(|k2 Create a Workrange - data validation cells onlyp NA1 %2%. !G'6cG !'6j Write the headers Data Validation Report for: !!;7!(Worksheet name: !; !Number of data validation cells: 6;Report generated: ;A1:I472!(A1:I472!(A5:I572!('Address 7(DRow 7(DColumn 7(DValue 7(DType 7(DOperator 7(DFormula1 7(DFormula2 7(D Ignore Blank  7(D In-cell Dropdown  7(DShow Input Message  7(D Alert Style  7(D 7  7725( 9$5(  7(  7(  7(  7(  7(  7(qq  ' 6! Examine each nonblank cell'    ' 4    6 ! (A@k(k  %  , !   t" F5B~xMEPS<S<S<S<<<  P I Rx% V%`X`Z \%`^`` `I I  %`` % (%````  ,VP IX 0@i ust ,p I v!i ,,P I 0 vi v   0 0J  ( "0 8HPX`.h60008 "@HPX`hp  $   H X`hpx 4           0  .@ p    ,   ( 8 H$X   .   (H h *  ..H P` " hpx  T (8@ H `p " ` @ H  8P   0     < P ,p : *  0 P p x      8 X "x & ( " &  @  H  X  `  p              ( (8`h x   (  ( HX x"   $ \ @Pp x  ($@&h&$&0&X&(Hh$&&0$H&p&$&8&`&0H`  h $  8( &0 Xp  4 8 "@ H hx  B  0H` x B   8 Xx,* B 0 Ppx "  " ,  " &(P `x]`]x]]]  (@  B9D H9Fq Settings ShowProgress$J'4 SettingsRememberSettings$J   obActiveOnly$J L(D   obAllSheets,0 !  ,P !D$'(error)  ,d' !D  ,kPH !H!l$V  ,H V avoid the error if a a data validation cell is merged with a non data validation cell8 !(none)  ,ole>kx !H!l-;KT any value  ,TD  ,io  ,  ,45  ,02KT wholetem !H!T$p  ,t L' !H!P  ,' !H!R  ,04 !H!  ,LO  ,xdKT decimal !H!T$p  ,D04' !H!P  ,3' !H!R  ,et !H!  ,̶  ,BKT listT@i  ,' !H!P  ,  , !H!  ,@ !H!  ,ppKT dateTru !H!T$p  ,orC' !H!P  ,$' !H!R  , !H!  ,ly  ,AKT time !H!T$p  ,each' !H!P  ,Z' !H!R  , !H!  ,  ,.KT text len !H!T$p  ,lk' !H!P  ,ា' !H!R  ,qy !H!  ,  ,KT custome  ,S' !H!P  ,"  ,_  ,C  ,#n !H!  ," !H!$  , nkH  ' t2 d  CellCount = 0"(No cells contain data validation)  ,k Fit the columns & header row    % ( A7:L1000 %2! B@    % !< G<  % (j 7:7 %!B@ o Maximize the speed v(x v!|$z  8 v!~(kX : v(o@ X ZKTF Any Value'V \KTF Whole Number'V ^KTFDecimal'V `KTFList'V bKTFDate'V dKTFTime'V fKTF Text Length'V hKTFCustom'V n@i8P  tKTFBetween'p vKTF Not between'p xKTFEqual to'p zKTF Not Equal to'p |KTF Greater than'p ~KTF Less than'p KTFGreater than or equal to'pt KTFLess than or equal to'p ni  KTFStop' KTFWarning' KTF Information'niP A@ro`& Cancel button in progress indicator  !B@BA A@rjgopup6.xla!ShowPUPHelp vB@oAttribute VB_Name = "UserForm1" " Bas0{D4F5A311-A883-423A-B6F5-A52A742484E1}{7E4C7F0A-F55F-4ADE-BB27-0CB75E69C636} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizDOp tion 0licit Dim ShowProgress As BooleanCellCount Long ErrorCheckingCalcSettInteger Outpu*WorksheeHPko Su b |_Initialize() Me.Ca3= APPNAMECWith MultiP0age1 .V(alue0StyjfmTabNon@d End A JI= Ge"tD6(PU, r"Ds"HU1 .IfRemember1)1 Thee' obAct@OnlyF7&H@% @%a * -E'DllScs'E B QIf uIyOKButton_C@kxSOriginal RkKEbook2)EdIaaHCMPiwkbahSMs]S ng, Anc  'Bc for protectubs@A1;;b.tACo`hntsaABox "`D aB is." & vbCrLf "A mula Report cannot be genTer@rdBaww.> tcal`" raaUnlo0ad MkExit}c"EbB!aA/@% Each 5In C&E.7D.+*& " @& Chr(149)`(" ?ԥ+aINe "";4aL+N=4sk?DAj cYKaiZ` Vmore=W:SH#%FK"!Uinanyway?6! f= `V(,RIn@ma+YesNo$T13vbNob/'bAo'R _J߱9sY :Jh7'o<=C#CHAdj{ s3ss to maxi|e the speedAppR.Scree0nUpdx= /2Xspo(Vers) >= 10R}P s.Backgr`d1n  Y ?0L$xlManual#[qe new 1q5ArR2eRsInNew o{ /k (s.Add!?1h s anl^c`(-b, `' Run(yEzZO z@ i3XZ.'  bi To;B@t(i), i) __i#-3'Ren!&VCZ mkDs .i=? *!)hen (1)-#BS#SavLufN &)4dq"'Rere eQt`4sht, nkaRangeqC Frm 0Sҥ1Sht2 U, !ۿ HeaderRowurrentdޡ*8erlK "Z7dgsLabeSNum 6= "Working on " & sht.NamePChr(13)$"Sheet|n8 of0@ActivebPook.sRs.Count  LabelProgress.Width = 0@DoEventsEnd If S~Output7v(n).ht=B#xxxyn  'UCheck for protected }If'c ContY The t 1Cells(1, 1)#X" iPa.r! s<. Report was not g eneraI."'G97.FL.Bold 0] š:0; ElseJ!ɥ-GoToŢÁWrite the headerWi\>`./Ez"DK/;q:́}FullqSize514 2ĖB nG3E R y<+4DŽTSNowj$c$>:I4 ?BTIztAle StylGLBUM, 2)hW%A.Wrap^T`KImrior`RlorIndex36w bBorAQ(xlEdgeLeft).Line\ hinuouSCaeTopn2t mIBopttomoeRigh/ / InsideVicalHoriz/! j !|%#Cur#OO+ 1pu6^guSp1Exam each@nb}8 61wPy=gEAA EA In"Ze 10 9XMod 1рC W/!(5/) * FruoqEu?b@v.$i(rowabs0dte:=Fa`x, c"el}D/t ", 2" i =QClkiIs(r"l)W??ns 4q "'(e)hYaKQ o88n7, 5 qy4.A\' avoid#r ifa ll is mergwaa: p "(noneҵMȡohGY1Sel@ CaA  0 nyA5""6''_<7_5 7S.8__s(9__^0z5 "" Case 1 ' w0hole|Output.Cells(CurrentRow, 6) = ValidationOperator(R...0),_7_@"'" & RFormula1,Qj8(2(9(NIgnoreBladnk,'10P2decimalo,,j.Djo\n.jObB3jlist1jʍ{CeQam6akn!Dropd(own/4Aeat65d+d+ 8855tim5ҟϔ55+55+ 55|gM6ext leO7ߒ/ rbgޔ!?4g2 J_u7customQtr5:_T@g_TB B _T End Selecl|K1n.ShowavElp'bCount0W "(No c c ain a v)dIf 'Fit theA@lumnsPheader rowSР Col 1 To 1WTu o(@).@AWidth3T oTtRange("A7:L 1000"s.pAuto  IfF'?3> 6@0 Thenl 6 p ows("7:7p Ere@ڗ ,ubPriv Sub Re0BreSet"gs(`#MaximizeAspeedA pplicuSc@reenUpngTruT|p*B(Vers@) >= 1#  ErrorCheckingOpbs.Back4gr'dUsnL&lNoft@ bCEqu  toRZWGrePr: thanLessU Z-  or eG?F"AlertStyle(alsKs|dop ( MStop.Warn`ZyInformajd #'rSublncelButton_Click()#"Unload MezIzm2'Ca b in progrQ`dic! @On Err HResume N@$utput.Parent.Cl:o@F5Call `eSett -sL GoTo 0$PUPHelpq"App@$1.Run "pup6.xla!Show", 645 _VBA_PROJECTAdirvF__SRP_0 Q__SRP_1 UsedRangeȉCellsParentFontUBold SpecialCellsxlCellTypeFormulas#ErroNumber-FullNameОSizeNow%Italic!WrapText}Interior; ColorIndexBordersC" xlEdgeLeftL LineStylew xlContinuous[ xlEdgeToph xlEdgeBottom xlEdgeRight%vxlInsideVerticaljMxlInsideHorizontal FrameProgressAddress rowabsoluteՒcolumnabsoluteq4RowColumniIsErrorU IsLogical| NumberFormatRHasArray FormulaLocalDFormulaR1C1Local Locked  FormulaHidden PrecedentsDirectPrecedents* Dependents2DirectDependentsRowsU EntireRowAutoFit& Columnsp9 ColumnWidthCancelButton_ClickCancelButton2_ClickȌHelpButton_ClickfRun_UserFormNFrame1Label1,OKButton| CancelButtonLabel2, CancelButton2v HelpButton InitializeNClick_Defaultj PUPHelpButtonFzPUPHelpButton_Clickv _B_var_Chr\; ActiveCellMultiPage1_ChangeJ _B_var_StringӊDataValidationReport HasValidationwcZChange _B_var_On6xo_B_var_x Validation IsEmpty ValidationCells+xlCellTypeAllValidationFormula1Formula2OperatorkValidationTypetkxlValidateInputOnlyxlValidateWholeNumberxlValidateDecimalGxlValidateListĤxlValidateDateLxlValidateTimeExlValidateTextLengthUxlValidateCustom _B_var_Select'E _B_var_caseWholerValidationOperator61of xlBetweenk xlNotBetweenXxlEqual- xlNotEqual|A xlGreaterxlLess;xlGreaterEqual~ xlLessEqualop^xlNotBetweenValidationOperator܇xlEqualValidationOperatorӝxlNotEqualValidationOperator?xlGreaterValidationOperator9xlLessValidationOperatoroValidationAlertStyle0als.txlValidAlertStopxlValidAlertWarning xlValidAlertInformation͈ ShowInput IgnoreBlankRInCellDropdown9 AlertStyle7_B_var_AlertStylep _B_var_SetValType_B_var_ValTypecsae _B_var_csae8 ValidReport+ _B_var_IfPContinueTx) HMacVBA6# FormulaRepAstdole`MSFormsCOfficeuSheet1 _Evaluate ThisWorkbook|Module1bPUPNAMEӆAPPNAMEKp FormulaReport  CheckAddIn ActiveSheet%NTypeName UserForm1)Showay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINNT\System32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{B2E8696D-4847-48FE-B221-040B87292B4F}#2.0#0#C:\DOCUME~1\jwalk\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\MSOFFICE\OFFICE\MSO97.DLL#Microsoft Office 8.0 Object Library &CTB Sheet13G432689d9 Sheet1@ThisWorkbook05431c44e4ThisWorkbookFModule14O43268aabModule1Г0UserForm14P43268aab)UserForm1~HL5h0H0~t֗'CcN9-A/1F "@c-*D3XF AsCase^GoTo_IfOutputResumeThenExcel+VBAWin16~Win32MacVBA6# FormulaRepAstdole`MSFormsCOfficeuSheet1 _Evaluate ThisWorkbook|Module1bPUPNAMEӆAPPNAMEKp FormulaReport  CheckAddIn ActiveSheet%NTypeName UserForm1)ShowCloseMe WorkbooksBSheets Range  ShowProgress_8 CellCountUserErrorCheckingUserCalcSettingT WorksheetUserForm_Initialize5cCaptionx MultiPage14?ValueKStylepfmTabStyleNone^ GetSetting obActiveOnly9 obAllSheetsнOKButton_Clickf OriginalBook"Workbookk OriginalSheet6 UserSheetCt|i`wksVMsgQAnsxtProtectContentsMsgBoxRvbCrLf vbCritical+}ActiveWorkbook WorksheetsChrK~ vbInformationnvbYesNovbNo% Application*ScreenUpdating! ValVersionErrorCheckingOptionsX'BackgroundCheckingp; CalculationhxlCalculationManualSheetsInNewWorkbookAddrGenerateReportCount0v SaveSettingRestoreSettingsSshtne FormulaCellse ConstantCells.) WorkRange@5FrmlaQShtName}nURangeCell HeaderRowI* CurrentRowSmCounterColH LabelSheetNumw LabelProgress}G{00020430-;C 0046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB# Automa0tion^MSForms>SFErms3DD452EE1-E08F-101A-8-02608C@4D0BB4 DNT\System32\FM20.DLL#Micr@osoft 9 \ Object Library/;C1s00}#0#j0 AB2E8696D-4847FE-B221-040B87@292B4F6DOCUME~1\jwalk\LOCALSTem@p\VBE\DS.8exd`;!.E .`M COfficDO@ficBz p02DF8D04C-5BFAgB-BDE5@ITAA@420MSOFFICE\397g 8\.0gDB´S@heet1G´Sh)e@1UH2NHB1B,@"B+BBThisWorkbookG@T@iWkbok@ [A 2opFliodule uio{u{ 27m -!Г!b %! Use6r!j@ er&ya2/L5o1~c1(@ brU~~~~~~~~o  1   I ( 8 H x  in  Parent P is protected. Report was not generated.FontBoldSpecialCellsFFfĤIx8< 8Data Validation Report for: FullNameSize Worksheet name:  BNumber of data validation cells: $Report generated:  A1:I4MF A5:I5 Address Value Row Column Value Type Operator Formula1 Formula2 Ignore Blank In-cell Dropdown $Show Input Message Alert StylepFUFTF '(error) '/DF D(No cells contain data validation)ColumnWidth A7:L1000 7:7EntireRowAutoFit V   ( " H / h Any Value Whole Number Decimal List Date Time Text Length Custom Stop Warning Information Between Not between Equal to Not Equal to Greater than Less than 0Greater than or equal to *Less than or equal to (none) CloseH3K؄AȽח FH K E&DF Worksheet!m LabelProgress FrameProgressUserForm_InitializeOKButSummaryInformation(-DocumentSummaryInformation8(CompObjmOh+'0x hp 4@ X dpPower Utility Pak v6PUP v6 Support FileJ-Walk & Associates Version 6.181999-2005 J-Walk & Associates. All Rights Reserved.John Walkenbach6.0Microsoft Excel@}Z@՜.+,0 XK*yrU~~~~~~~~~~~~~~~~~~~~~~~~~) 1XI\<,,    Sheet1 ThisWorkbookModule1 UserForm1 ValidReportF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA Q y0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel Iq@0FC:\WINDOWS\SYSTEM\STDOLE2.TLBstdole CheckAddIn YP.E .`M C:\WINNT\System32\FM20.DLLMSForms aa`miGHH! )+O /C:\DOCUME~1\jwalk\LOCALS~1\Temp\VBE\MSForms.exd 9aapL-[DRC:\MSOFFICE\OFFICE\MSO97.DLLOffice !I "Power Utility Pak ,Data Validation ReportDataValidationReport FF)Q Worksheet#zCKBƈeA x=`m;Ja\9XdG']/"=UNnH$xIMV=hO*ȏ[qJ eUserForm"`%A?Oo F3Dynamic  ?F`Frame1!-6S` "-?@Label1{lFWJOOKButton CancelButton{lFWJO MultiPage1Label2 CancelButton2RҋB ` obActiveOnly obAllSheets PUPHelpButton LabelSheetNum LabelProgress FrameProgressUserForm_InitializeOKButton_ClickGenerateReportRestoreSettingsValidationTypeValidationOperatorValidationAlertStyleCancelButton_ClickCancelButton2_ClickPUPHelpButton_Click @)VBE6.DLL obAllSheets O  A1 pup6.xlaFFF Range Utility;RׯF"+GFxCOk޻zDFWorkbook @ɏYl| Settings ShowProgress RememberSettings obActiveOnlyCҋB `   X (pup6.xla!ShowPUPHelpF#=h8+3qG?,2qL 1 x,+kMVjڎ&ProtectContents <The active sheet is protected.  ! ~A Formula Report cannot be generated for a protected worksheet. F  ! |A Formula Report cannot be generated for protected worksheets. rThe activeworkbook contains one or more protected sheets: Continue anyway?Name S  `  E    Working on  Sheet   of Yl|ƏYl| xxUserForm1,/fo(i07pFz?a,,O]  :IP) !"#$%&'(*+,-./0123456789Y<=>?@BCDEFGH;J_LMNkRSTUVWXK[\` bacdefghijfoi09i*WJO,,i10i*WJO,,CompObjsx0foRoot Entry FG1;Workbook.? _VBA_PROJECT_CUR",*'/VBA+',Xshtntopals h .xJ(H  P@'}R KQDBTahoma0 ( #9MultiPage1  O  pFz?aMicrosoft Forms 2.0 FormEmbedded ObjectForms.MultiPage.19qge l1? Page1ii18# n``,,CompObjnf$o i01!& n``,,CompObjnfo"$8Page2iTab3Tab45Tahomag$H P}? p$ #Page12$5,$ !Page22$5, P i*WJOMicrosoft Forms 2.0 FormEmbedded Object Forms.Form.19q ( Working on...5TahomaonCompObjpfo%'CompObjp4($Generating Data Validation Report...7+@Tahomaon(CancelonquTahomaon$H P }0 2@LabelSheetNum(2XLabel2$X0 ?8CancelButton2U , #FrameProgress\ S i*WJOMicrosoft Forms 2.0 FormEmbedded Object Forms.Form.19qp(_This utility creates a report that lists all all cells in a worksheet that use data validation.c5Tahomag(OK quTahomag(CancelquTahomaaR KQltBM6(uTahoma$H }(2Label1+(74OKButton[ $#Frame1on+5, ?8CancelButton , PUPHelpButtonK  S n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q#"a5Tahomaon,J  P}8 0 P28LabelProgress S n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q@Fs01Active sheet only5TahomaPF!A00All sheets in the active workbook)5Tahoma<H   }tReport scopeR KQDBTahoma\( `obActiveOnlyX( pobAllSheetsyX S S Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm1 Caption = "UserForm1" ClientHeight = `|  Excel Add-In ToolsJWalk & Associates Sheet1  Worksheets F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q