- last edited on
A complete ignoramus here! Please, can anyone advise?
The situation is this, I am working on a MacBook 13" with Microsoft Office 2016. I have just taken over as treasurer of our little club. I have a workbook of just six pages with names scattered all over them.
I want to find all the occurrences of the name "Smith" so I put it in the search box and no problems EXCEPT it is so hard to see!
I have found a macro which turns the cell yellow when it is active which is really helpful. Please see below.
Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Static xLastRng As Range
On Error Resume Next
Target.Interior.ColorIndex = 6
xLastRng.Interior.ColorIndex = xlColorIndexNone
Set xLastRng = Target
But I cannot save it! It keeps asking me to save in a different format which I do but still no joy.
Please, could someone clever enough to know the answer and also clever enough to explain it in layman's term.let me know?
If you can a donation to a charity will be made. Mike T
12-10-2017 06:53 AM
If you want to save a workbook contains macros, then you have to save it in one of these formats:
I recommend you to use the first one.
by Flambert86 on August 02, 2020
by Derek-Ude on July 23, 2020
by npfox1 on July 14, 2020
by MS Excel Team on May 29, 2019
by Prash Shirolkar on September 25, 2018
by Blake T Walsh on August 23, 2018