Hello,
** Additional Info: I am using Excel 2013, no later versions are available **
** Spreadsheet attached **
I have a worksheet that contains URLs that have been blocked. When a URL is entered, it highlights if it has already been entered. For ease, I have tried to create a macro that un-protects the sheet and deletes the current ROW.
This macro works fine if I go into Macros, highlight it and select "Run" however if I assign the macro to a button on the ribbon and click on it, it tries to re-open the spreadsheet and I cannot work out why.
To get the macro, I simply recorded the actions and saved it....
Please could someone take a look and explain where I am going wrong. Thank you
Bookmarks