If the file is accessed only in one version, you don’t want to use this feature.Save As a normal *file to eliminate the feature from your file.
Because of the nature of such problems, it is important to provide feedback when you solve your problem by replying back to the thread so that others can be helped and so that pages such as this can show relevant information.I have decided to allow the user to query three fields: Office, Department and Gender.You will see that the code that powers the dialog box is easily modified to suit any number of fields.Sub Delete Blank Rows1() ' Deletes the entire row within the selection if the ENTIRE row contains no data. ' We use Long in case they have over 32,767 rows selected. Screen Updating = False ' We work backwards because we are deleting rows. Now when you click on the E-Mail Sheet button and if your e-mail client is Outlook, a new Outlook message should be created with Sheet1as the attachment (which is ONLY Sheet1 from the workbook).