I need your help on "how to lock the scroll area" in the excel workbook. I have tried the below but it is not working when I close and re-open the workbook (I have saved the work book before closing).
Alt+F11----->View---->properties window--->scroll area---> I have provided...
Hi, Can you please help me in adding "search by text" option in excel 2010 using VBA code. The basic idea is - with this "Search by text" option user can search the tool using specific "key word". The data is present in one excel sheet and the out put of the search should appear in another...