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?
Re: Working With Worksheets In VBA Ozgrid product
sorry I can see now I should have started this in Excel Help, my apologies.