LinkBack URL
About LinkBacks
Hello Evryone
I Want button of Bellow on userform
1= Save Workbook
2= Select Print Area
3= Add Quick Print
thanx
How to save a workbook using button
Hello Evryone
I Want button of Bellow on userform
1= Save Workbook
2= Select Print Area
3= Add Quick Print
thanx
Save means saving a workbook in a location or just saving it which is already saved in a location?1= Save Workbook
This can be done easily using Application.inputbox option for getting the range2= Select Print Area
Recording a macro and give print which will get you the needed code3= Add Quick Print
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hello
workbook save code found it
and for printareaset and then print area are below,............but i want to add a printpreview before print.....if i ok then prin if no then cancel the print
thanx
Please Login or Register to view this content.
Not sure about who will determine Ok / Cancel action?Originally Posted by haroon2015
ok
when i select the range of worksheet and click the button assign with macro(SelectPrintArea)
then select the range and show the print preview with option of yes or no,
if i click ok then print else cancel the print and deselect the range
thanx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks