Speed and efficiency considerations can be seen in Proper, and other Text changes and in Slow Response.The DEL95HTMLempty Cells is designed to clean up the mess that Excel 95 creates when pasting from a web page into Excel.The problem with both i Devlop's and Ashok's answers is that the fundamental problem is an Excel design flaw (apparently) in which the Open method fails to respect the Application. Consequently, setting it to False is of no benefit to this problem.If Patrick Mc Donald's solution is too burdensome due to the overhead of starting a second instance of Excel, then the best solution I've found is to minimize the time that the opened workbook is visible by re-activating the original window as quickly as possible: Dim Temp Wk Bk As Workbook Dim Current Win As Window Set Current Win = Active Window Set Temp Wk Bk = Workbooks. Activate 'Allows only a VERY brief flash of the opened workbook Temp Wk Bk. Visible = False 'Only necessary if you also need to prevent 'the user from manually accessing the opened 'workbook before it is closed. I want this to work regardless of the previous filters. I don't want to see any other rows in the pivot table. Sub Filter Pivot Field() Dim Field As Pivot Field Field = Active Sheet. Pivot Fields("Saved Family Code") Value = Range("$A") Application. Ignore those errors at your peril - your application will eventually freeze or crash. For example if the workbook contains product names and price data it can be hidden and you can show an Excel file that represents an invoice with drop downs for product that validates from that price list.Microsoft do not acknowledge that this problem exists, and there is no documentation on it whatsoever. You can then store the price list on a shared location on a network somewhere and make it read-only.
Is there a way to have them open "in the background", so to speak? There are a few tutorials floating around on the web with the particulars of what you can and can't do accessing a sheet this way. :) @Shawn Zhang Most of the Excel files we've been reading have been exported in the 2000/2003 format since that's what the sender's program emits. Dim w As Workbooks Private Sub Workbook_Open() Application. Open Filename:="\server\Price List.xlsx", Update Links:=False, Read Only:=True 'this is the data file were going to be opening Active Window. By doing it this way though you will not get prompted to save changes back to the Excel file your reading from.If you close the toolbar by clicking the X, it will disappear again.This will cause the function to be executed whenever a calculation occurs in the workbook.Some buttons are Form Controls and other buttons are Active X Controls.If you right-click a button from Form Controls, the popup menu includes the Assign Macro command. Visible = False End With End Sub But I want all except K010 to become invisible The macro recorder ignores my select/deselect all clicks Sub Filter Pivot Field(Field As Pivot Field, Value) Application.