Hi everyone.
In the attached workbook there are 2 sheets.
In sheet1 there is a data validation that changes the number by updating the values in sheet2
I ask for help to do this:
Print all sheets in one shot without selecting the number and then printing.
The numbers in this case are 9 but can be many more.
I hope I explained myself.
Thanks in advance.
max
Do you not have the option to print the entire workbook in your print function?
If not try something like:=
Please Login or Register to view this content.
Last edited by mehmetcik; 10-16-2018 at 03:40 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Must do this:
Data validation / combobox 1 in sheet1> print sheet2
Data validation / combobox 2 in sheet1> print sheet2
Data validation / combobox 3 in sheet1> print sheet2
Data Validation / Combobox 4 in Sheet1> Print Sheet2
Data Validation / Combobox 5 in Sheet1> Print Sheet2
combobox / validation data numbers can be more than 5
max
Maybe
Please Login or Register to view this content.
Maybe
I cannot post the code to select Foglio1 before running the macro. Insert that your self.
Please Login or Register to view this content.
I tried the macro and it looks like it runs well.
A greeting
max
Hello
XXXXXX
Last edited by max_max; 10-18-2018 at 04:18 PM.
Hello
because it does not work?
Now the imputbox is in I4 and continues to debug here:Please Login or Register to view this content.
If Cells (count, 3) = "" Then GoTo Skip
max
Please Login or Register to view this content.
Because not work?
You are using the Defined Name Numeri for Data Validation.
Numerie refers to B17 to B32 on Sheet Lingua.
So....
Please Login or Register to view this content.
Thanks melmetck
We're at a good point.
Now there is no mistake.
A problem:
must only print as sheet numbers only if cells
lingua > B17: B32 are not empty
in cell I4 (stampa marche) must reset
Anyway thank you very much.
max
Last edited by max_max; 10-19-2018 at 12:42 PM.
It's a mystery now it does not work anymore
1. Put this formula in cell B17 on linguaFormula:
Please Login or Register to view this content.
2. Try this version
Please Login or Register to view this content.
Thanks mehmetcik,
here at home it works.
Monday I try in the office.
Thank you so much.
Greetings and thanks again.
max
Hi mehmetck the macro works well.
is a change possible?
now if the macro part is I have many sheets to print I can not stop the macro and print all the sheets.
is it possible at any time to stop the macro and cancel everything, maybe connected to a button
with warning:
do you want to stop the print?
Yes / No
Thanks in advance.
max
Please Login or Register to view this content.
Last edited by max_max; 11-04-2018 at 04:08 PM.
Click: ESC
it's right?Please Login or Register to view this content.
max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks