"Missing argument" when calling program from button

**LydiasDad** · 02-26-2014, 03:06 PM

I don't why, but the compiler keeps screaming about this macro when I call it from a button. It used to work, and I'm not sure what changed. Why is an argument required simply because I'm using a button now? See the picture. The Sub MainFormattingMacro() line is highlighted if I hit Debug.

**TMS** · 02-26-2014, 03:14 PM

Not sure what you would have us do with a picture of an error. We (at least I) can't see the code, let alone diagnose the problem with it.

Regards, TMS

**LydiasDad** · 02-26-2014, 03:21 PM

I was somehow able to revert back to my previous "working" version of the macro. Let me try to add the new functionality little by little until it breaks. Thanks.

**TMS** · 02-26-2014, 03:31 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.