Compile Error: Invalid Outside Proceedure

[Tenbapps]

Hello,

Having an odd issue with my spreadsheet which you can see below. I'm a travelling sales rep, just started working at the company and I'm arranging all the info in my own way.

This sheet is to show me the accounts I visit and the date that I last visited them. I made the column headers into buttons, so that when you press them it will sort the accounts alphabetically or show the order of the last visit I made to them.

These are the macros:

Very simple and until 3 days ago, they worked fine and now whenever I press the buttons I get this:

When I click "OK" I get this:

As you can see, it highlights the Hypoid sheet for some reason as where the error is. Thing is the macros have nothing with any other sheet than the one they're in!

Any ideas please?!

 

[VoG]

Right click the Hypoid sheet's tab, select View Code, delete the extraneous letter t that has found its way in there then press ALT + Q to close the code window.

 

[Tenbapps]

Sorted, thanks!

Any idea why that "t" appeared?

 

[VoG]

No idea, sorry.