I have a macro that allows me to delete certain rows based off a specific text value from a specific sheet only, this seems to only work as long as I am active on the sheet named Apple however I want to be able to run a macro enabled button while I am on a different sheet and I keep receiving an...