Search results for query: *

Sorry but i dont know the first thing about VBA i wouldnt know how to use the workbook_beforesave thingy. Also included the clearhighlights but it doesnt work for me, maybe ive done it wrong but i just copied and pasted the whole list of coding into my spreadsheet. Sorry if im being trouble. If...

What ya mean huh? that coding you provided highlights all the cell it finds but what i asked for it to do was maybe clear the highlighted cells back to the normal aqua colour after maybe 10 mins of when the user saves so theres not random red cells everywhere where previous searches have been...

Your correct, it doesnt work. it just leaves the cells highlighted. All ive done is recorded a macro that clears all those highlight cells. Im sure theres a way that when you ask it to save the sheets it should clear the highlight cells back to the awau background i use on all my sheets

Thank you very much. i can stop pullin my hair out now lol

Sorry but where would i put that so once its found the data and highlighted it in the red it'll clear before it saves. This'll be the last question thanks for your quick replies. Ive been searching on the internet for weeks

Brilliant that worked a treat but one more problem sorry. When it finds the item your looking for it colours the cell in red (All sheets in an aqua colour) and they stay red unless you go in and change the colour of each cell manually. Is there a way around this so when the user saves the...

Brilliant ill give it a go tomorrow. Thanks

This is the VBA code i have used Sub Button1_Click() SearchString = Application.InputBox("What are you looking for?") Range("A5:F1000").Select Range("F1000").Activate On Error GoTo Woops Selection.Find(What:=SearchString, After:=ActiveCell, LookIn:=xlValues, LookAt _...

Ive created an excel spreadsheet for work to search available fitters but ive created a search string with an application box but my problem is it only highlights one word in the sheet. If i had dog in A1 and dog in B1 it would only highlight dog in A1, any one advise me on what i can do to get...