L Ljm New Member Dec 18, 2013 #1 Hello, is there a way to make appear by default Find and Replace dialog box once an excel file opened? Do I need to create a vba macro for this? I want to avoid using Ctrl F shortcut.
Hello, is there a way to make appear by default Find and Replace dialog box once an excel file opened? Do I need to create a vba macro for this? I want to avoid using Ctrl F shortcut.
B BBD Member Dec 18, 2013 #2 Hi Ljm, Yes this requires VBA which activates the event - Workbook_Open.
B BBD Member Dec 18, 2013 #4 Hi Ljm, Here is the VB. You need to place in the Thisworkbook module. Code: Private Sub Workbook_Open() Application.CommandBars.FindControl(ID:=1849).Execute End Sub Cheers, BD
Hi Ljm, Here is the VB. You need to place in the Thisworkbook module. Code: Private Sub Workbook_Open() Application.CommandBars.FindControl(ID:=1849).Execute End Sub Cheers, BD
