Macro to automate 'find' function
Posted by Chris Choulos on August 03, 2001 12:27 PM
I am in need of a macro that will automate the find function. Specifically, I have an excell spreadsheet linked off of a web page that is being used as a searchable database. When the spreadsheet is opened, I would like the 'find' dialog box to come up automatically so that the user can simply enter the text to be located and hit return. Basically, it's automating the manual task of having the user go into the Edit menu and selecting 'find'.
Thanks in advance for any suggestions,
Chris