In the Visual Basic Editor, go to the Tools menu, and click VBAProject properties. Sub Select Web Page To Open() Dim The Page As Variant The Page = _ Application.On the Protection tab, click in the box to add a check mark for "Lock the project for viewing", Enter a password, and confirm the password, then click OK. A workaround is to simulate keystrokes with the Send Keys method Sub Find Last Cell() Dim Last Cell As Range With Active Sheet Set Last Cell = . Get Open Filename("Webpage (*.htm*), *.htm*", _ , "Pick one:") If The Page = False Then Msg Box "You cancelled" Else Msg Box "Do something with file " & CStr(The Page) End If End Sub Sub Select Save File Name() Dim The File As Variant The File = Application.An Excel macro has been added and then removed, leaving an empty module.Empty modules trigger the macro query, as does an actual macro.For cells that are manually changed, you can use a worksheet change event to call a macro.Be sure to protect your macro code to hide the sheet password. End(xl Up) If Is Empty(Last Cell) Then 'do nothing Else Set Last Cell = Last Cell. Row End Sub Note: You may want to reset the last cell For many tasks, there might be a faster method than looping through all the cells, but if you need to loop, you can use For Each... In this example, the font in each cell is changed to bold.To see the steps for removing this warning, please watch this short video tutorial. The next time you record a macro, the toolbar should automatically appear.Note: When you're finished recording, click the Stop Recording button.
They just change the Visible Drop Down property to False, for some fields. NOTE: Use the Field number, NOT the worksheet column number. Rows(1) i = 1 i Show = 2 'leave this field's arrow visible Application. Auto Filter Field:=i, _ Visibledropdown:=False End If i = i 1 Next Application. Auto Filter Field:=i, _ Visibledropdown:=False Case Else c. You can change the field number in the i Hide variable, to hide a different field's arrow. Auto Filter Field:=i, _ Visibledropdown:=False Else c. If you don't want the dates grouped automatically, you can: Perhaps you want users to filter only specific fields in a list. Auto Filter Field:=i, _ Visibledropdown:=False i = i 1 Next Application. Special Cells(xl Cell Type Visible) On Error Go To 0 End With If rng2 Is Nothing Then Msg Box "No data to copy" Else Worksheets("Sheet2"). Use the following macros to hide one or more of the drop down arrows in the list heading row. Screen Updating = True End Sub The following Excel Auto Filter VBA procedure hides the arrows for all fields except field 2. Auto Filter Field:=i, _ Visibledropdown:=True i = i 1 Next Application. Below are archived posts from the Mr Excel Message Board about Microsoft Excel VBA.You will find lots of tips and tutorials for using visual basic in Excel.