+ Reply to Thread
Results 1 to 2 of 2

invalid outside procedure error

  1. #1
    Registered User
    Join Date
    11-02-2009
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    invalid outside procedure error

    Hi,

    I'm working on a Excel workbook where I've tried to record a few extremely basic macros, but each time I try to run it, I get the same "Compile Error: Invalid Outside Procedure" error. I'm then taken to the same Microsoft Visual Basic page which has this on it -

    MultiUse = -1 'True
    End

    How do I fix the problem? Thanks in advance.

    EDIT: Code tags added. My apologies for not including it before.

    EDIT2: I copy pasted all the worksheets into a new workbook, and tried the "getdata" macro (see below), which worked at first. After I saved the file
    the same macro stopped working, and I got the earlier errors. What gives?

    Examples of the macros -

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by trum01; 11-02-2009 at 06:27 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: invalid outside procedure error

    Please Login or Register  to view this content.
    by the sound of it the above resides stand-alone in some module or object (ie outside of standard routine etc...) and as such needs to be remvoed (it's an incomplete piece of code).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1