Posts by JohnRB

    Re: VBA code to count of the number of custom formats, objects and pivot tables on a


    Quote from Ger Plante;793214

    Something like this....


    Press CTRL+G in the VBA window to see the results


    Ger


    Hi Ger I know your code was a quick one but modified it a tad in case a ws has no Conditional Formatting - the 'on error resume next' doesn't skip the error



    John

    Hi

    I bought the above OzGrid VBA learning tool which when downloaded for XL2003 is Worksheet-Macros.xls and I am a bit puzzled on how it is supposed to work.

    When I open the spreadsheet it fell over with the error message:

    Ambiguous name detected

    which relates to the module ProtectedSheetCode sub Workbook_Open and sure enough when I look further there are 2 subs with the same name in the ProtectedSheetCode module. So this spreadsheet was never going to open without a problem.

    I renamed one of them and that lets me get in and read through the code and comments which is all very useful stuff. There is no menu just read through the modules is that it or am I missing something?

    thanks
    John