Hi,
I am have changed around the below macro to work on a few of my sheets. I have a few different buttons that I allow the user to click, and also a cell for them to type into when for the key words that they want to search.
I want to protect multiple sheets(not the entire workbook) so that they can't move the buttons around. However when I do this the macro stops working. I tried ticking all boxes to eliminate the issue when protecting the sheet, but even with them all ticked the macro doesn't run.
Thanks in advance
Colin
Bookmarks