HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
I have the following in a macro for the command button 'Print':
ActiveSheet.PrintPreview
My question is once you execute this, it makes dashlines around the worksheet. After I print and come back to this worksheet how do I take away these dashlines? Also if I use the PrintPreview command, and the user chooses 'Cancel' how can I know they hit Cancel and not OK from the PrintPreview screen?
Thanks your any help. Nancy
ActiveSheet.PrintPreview
My question is once you execute this, it makes dashlines around the worksheet. After I print and come back to this worksheet how do I take away these dashlines? Also if I use the PrintPreview command, and the user chooses 'Cancel' how can I know they hit Cancel and not OK from the PrintPreview screen?
Thanks your any help. Nancy