Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).Īmong them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.įeel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Thank you for your joining us and glad to have you here.Īs a starting point I'd recommend you to read the green sticky topics at this forums main page. How can I change this so that all selected pages come up in print preview at once?įirst of all welcome to Chandoo's website Excel forums. MsgBox "The following Sheet was indicated to print, but not found in the workbook: " & prnSheets & "." & vbCr & "Program is halting" ![]() ![]() ![]() Set wkshtTemp = Worksheets(prnSheets.Text) Set prnSheets = Range("prnSheets").Offset(1, 0) The goal is to have the print preview screen come up for each item that is "checked." The code I have entered will activate print preview, but it will only display one sheet at a time (ie I have to close print preview every time I want to look at a new sheet). I have set up a series of checkboxes that correspond to individual worksheets in my workbook. I am having some trouble with a Print Preview command.
0 Comments
Leave a Reply. |