Macro - "Invalid Outside Procedure"

[Rickathome]

Macros have been working fine but I must have inadvertently key stroked something while accessing tools/macro. Trying to use existing macros gets "Invalid Outside Procedure" error. I can manually create a new macro but get the same error message when trying to use it.

 

[Fluff]

Hi & welcome to MrExcel
That means you have something either before

Sub a macro()

or after

End Sub

 

[Rickathome]

Thanks for your response. In the edit screen no entries appear pre or post the macro wording. Oddly, none of the macros I created for this particular file will run and the problem is exclusive to this file. UGH.

 

[Fluff]

When you get the "Invalid Outside procedure" error it should highlight the offending item.

 

[Rickathome]

When you get the "Invalid Outside procedure" error it should highlight the offending item.

Got it. Problem fixed. Many thx for your help !!

 

[Fluff]

You're welcome