SBendBuckeye
Programmer
Hello all,
We have some code that uses FileSystemObject to do a Print Preview for each file in a selected folder. When the user clicks Close it goes to the next one.
Can you add a custom button Cancel to the list of buttons displayed in PrintPreview? I have created and modified the CommandBars/CommandBarControl collections before in 'standard' Excel, but I am not sure how to go about doing the same things in the PrintPreview form.
Thanks in advance for any ideas and/or suggestions!
We have some code that uses FileSystemObject to do a Print Preview for each file in a selected folder. When the user clicks Close it goes to the next one.
Can you add a custom button Cancel to the list of buttons displayed in PrintPreview? I have created and modified the CommandBars/CommandBarControl collections before in 'standard' Excel, but I am not sure how to go about doing the same things in the PrintPreview form.
Thanks in advance for any ideas and/or suggestions!