Announcement

Collapse
No announcement yet.

Working With Worksheets In VBA Ozgrid product

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Working With Worksheets In VBA Ozgrid product



    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

  • #2


    Re: Working With Worksheets In VBA Ozgrid product

    sorry I can see now I should have started this in Excel Help, my apologies.

    Comment

    Working...
    X