Macro / VBA Script to delete ROW(s) on locked worksheet

Hi,
Attach the file please so we can look closer.
My first guess. The reason may be that "ActiveSheet" object isn't assigned correctly when working from a ribbon. Try Application.ActiveWorkbook.Sheets(1) or Application.ActiveWorkbook.Sheets("Sheet_Name_Here") instead of ActiveSheet.

Hi,

I have tried your suggestion and it doesn't work, it doesn't like the '.Sheets' section of either of the lines mentioned above. I did forget to mention that I am using Excel 2013, there is no later version available. I have added a copy of the speadsheet with a 'test' line.

** UPDATE - RESOLVED **

OK, so I have resolved the issue but not entirly sure how I did it.

Code I used;

Please Login or Register  to view this content.

I started a new spreadsheet and re-created the macro which worked. It worked by running the macro and from a keyboard shortcut but was still failing when I assigned it to a ribbon button. Then I changed the option "Customize Quick Access Toolbar" so that it was for the specific spreadsheet and not for all documents. The button is now working.