VBA Command Button not working

I created a command button with a VBA code to print invoices for clients. Yesterday, when I clicked the button it worked, but now when I click the button nothing happens. I have tried all the fixes. I have deleted the button and reset it. I have gone into the VBA design mode and tried running the code from there. Nothing happens.



I can't figure out why. I have updated, ran the fix from Microsoft, deleted the .exd files, and still nothing. Can someone please help? Here is a copy of the code I wrote.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You need to step through the macro to see where it fails.

Instead of clicking on the button, move the macro to a normal macro module.

Then select the developer tab and then macros.

Select "Step into Macro" and then f8 to stem through your macro.

The behavior could be explained if there are fewer than 10 rows in "June 2017 SL Fees". If you run the code directly from the VBA editor and it still doesn't do anything, the problem is not with your button. Also see if the code is even trying to run--as a quick diagnostic I suggest putting this line just before the For statement:

Please Login or Register  to view this content.

If the message box doesn't appear then your code is not even running. But if it does appear, the problem will likely be evident in the message.