Change Workbook Parameters In Workbook. The image below shows the visible case where ShowDetails is Yes. The pattern is Parameter N so if we want to add to them the next name will be Parameter N1.
Notice that the chart below disappears. Lets look at how to add parameters some common ones and a little cheat sheet I use to quickly start a new workbook. Choose Add from the toolbar and select Parameters from the dropdown.
You can set your dynamic parameter to default to a specific value when the workbook is opened.
Click on this drop-down menu. ReservedWorksheetName if a reserved worksheet name is used. Sub WorksheetObject Dim wks1 As Worksheet Dim wks2 As Worksheet initialize the objects Set wks1 Sheet1 Set wks2 Sheet2 rename the sheets wks1Name Customers wks2Name Products set the objects to nothing wks1 Nothing wks2 Nothing End Sub. To illustrate how to pass filters and parameters between workbooks Im going to start by changing the Minimum Date and Maximum Date parameters in the splash page style dashboard featured in the second UI tip in in this series.
