Hillster wrote: < when I pasted your code into my master Workbook, then added the form control buttons, click them. it keeps opening your copy of the example work sheet>
The macros associated with the Control Buttons are still pointing to my file - a powerful feature of Excel when you want that feature.
Since you want the macros to point to your file, you have to reassign the buttons to point to the Macros of the same name in your file:
a. Right Click the Command Button
b. Select 'Assign Macro' and select the appropriate Macro, then select 'OK'.
Lewis
Bookmarks