Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Find Dialog at WorkbookOpen
I was wondering how I would make it to where everytime I open a specific
workbook the Find box automatically starts with the parameter to search the entire workbook? I tried to use the SendKeys function but man that was messed up. I tried to record a macro and tweak it but that never worked. Thanks In Advance, R |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Find Dialog at WorkbookOpen
How about:
Sub Answer() SendKeys "^f%h{down}~" End Sub "Rob" wrote in message ... I was wondering how I would make it to where everytime I open a specific workbook the Find box automatically starts with the parameter to search the entire workbook? I tried to use the SendKeys function but man that was messed up. I tried to record a macro and tweak it but that never worked. Thanks In Advance, R |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Find Dialog at WorkbookOpen
It Works!
Thanks Much! R "Bob Umlas" wrote: How about: Sub Answer() SendKeys "^f%h{down}~" End Sub "Rob" wrote in message ... I was wondering how I would make it to where everytime I open a specific workbook the Find box automatically starts with the parameter to search the entire workbook? I tried to use the SendKeys function but man that was messed up. I tried to record a macro and tweak it but that never worked. Thanks In Advance, R |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Find Dialog at WorkbookOpen
-- Steve "Bob Umlas" wrote: How about: Sub Answer() SendKeys "^f%h{down}~" End Sub "Rob" wrote in message ... I was wondering how I would make it to where everytime I open a specific workbook the Find box automatically starts with the parameter to search the entire workbook? I tried to use the SendKeys function but man that was messed up. I tried to record a macro and tweak it but that never worked. Thanks In Advance, R To Bob Ulmus What can I add to your following code to have it search only on Column A and make it read only ? Sub Answer() SendKeys "^f%h{down}~" End Sub Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open dialog box | Excel Discussion (Misc queries) | |||
excel and VB Open Dialog box | Excel Discussion (Misc queries) | |||
Open dialog box size | Excel Worksheet Functions | |||
workbookopen doesn't function | Excel Discussion (Misc queries) | |||
How can I make the find dialog box appear as soon as I open a spr. | Excel Discussion (Misc queries) |