Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Working With Worksheets In VBA Ozgrid product

  1. #1
    Join Date
    10th March 2010
    Posts
    2

    Question 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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    10th March 2010
    Posts
    2

    Lightbulb Re: Working With Worksheets In VBA Ozgrid product

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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 4
    Last Post: July 29th, 2010, 06:50
  2. So That's How! Working With Really Big Worksheets
    By Dave Hawley in forum Free Microsoft Excel 2003 Tutorials
    Replies: 0
    Last Post: October 23rd, 2007, 13:41
  3. product sum not working
    By jessepaull in forum EXCEL HELP
    Replies: 10
    Last Post: June 9th, 2006, 00:22
  4. Sum Product Function Not Working!
    By Nakpi in forum EXCEL HELP
    Replies: 10
    Last Post: November 11th, 2005, 01:02
  5. Sum Product not working
    By sythong in forum EXCEL HELP
    Replies: 3
    Last Post: February 20th, 2005, 19:25

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno