VB script to notify/popup
Solved/Closed
Sammysen
Posts
2
Registration date
Tuesday August 5, 2014
Status
Member
Last seen
August 5, 2014
-
Aug 5, 2014 at 02:23 AM
Sammysen - Aug 14, 2014 at 09:38 PM
Sammysen - Aug 14, 2014 at 09:38 PM
Related:
- VB script to notify/popup
- Send popup message to another computer on network windows 10 - Guide
- Does instagram notify when you change your profile picture - Guide
- Edge open new tab as popup - Guide
- Viber popup after call - Guide
- Anu script manager 7.0 free download filehippo - Software Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 5, 2014 at 10:51 AM
Aug 5, 2014 at 10:51 AM
Hi Sammysen,
Have you checked all the print options? There should be something like print Active sheet, all selected sheets, entire workbook.
Have you tried selecting multiple sheets (while holding Ctrl) and then print?
Which Excel version are you using (like 2003 or 2010 etc.)?
Best regards,
Trowa
Have you checked all the print options? There should be something like print Active sheet, all selected sheets, entire workbook.
Have you tried selecting multiple sheets (while holding Ctrl) and then print?
Which Excel version are you using (like 2003 or 2010 etc.)?
Best regards,
Trowa
Sammysen
Posts
2
Registration date
Tuesday August 5, 2014
Status
Member
Last seen
August 5, 2014
Aug 5, 2014 at 09:30 PM
Aug 5, 2014 at 09:30 PM
Trowa,
I'm using Excel 2007.
Clarification to my inquiry above, it is the 'work sheet' that sometimes forgot to be printed and not a 'sheet' in a 'work sheet'.
Sorry for the confusion.
Sammysen
I'm using Excel 2007.
Clarification to my inquiry above, it is the 'work sheet' that sometimes forgot to be printed and not a 'sheet' in a 'work sheet'.
Sorry for the confusion.
Sammysen
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 7, 2014 at 10:07 AM
Aug 7, 2014 at 10:07 AM
Hi Sammysen,
A sheet is the same as a worksheet.
An Excel file / Workbook contains 1 or more sheets / worksheets.
If you want to print multiple workbook; try selecting the ones you want to print > right-click > select print.
Is that what you wanted to do?
Best regards,
Trowa
A sheet is the same as a worksheet.
An Excel file / Workbook contains 1 or more sheets / worksheets.
If you want to print multiple workbook; try selecting the ones you want to print > right-click > select print.
Is that what you wanted to do?
Best regards,
Trowa
Trowa,
Yes, I practically know that process in particular.
In our setup, we have limitation that prohibit to proceed with selecting all the active sheets, thus we end up printing our requirements one by one. Now the problem is because of this limitation, we sometimes forget to print the other required sheet.
Having said that, I would like to ask if we can add VBA SCRIPT that may notify the to print the the other sheet(s) after we print the other one.
Thank you for your assistance.
Sammysen
Yes, I practically know that process in particular.
In our setup, we have limitation that prohibit to proceed with selecting all the active sheets, thus we end up printing our requirements one by one. Now the problem is because of this limitation, we sometimes forget to print the other required sheet.
Having said that, I would like to ask if we can add VBA SCRIPT that may notify the to print the the other sheet(s) after we print the other one.
Thank you for your assistance.
Sammysen
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 11, 2014 at 11:54 AM
Aug 11, 2014 at 11:54 AM
Hi Sammysen,
That is a some strange limitation you have there.
See if this code works for you. It will loop through all the sheets in the workbook you run the code from.
In case you don't know how to implement the code / run the code:
- Hit Alt+F11 to open Microsoft Visual Basic window.
- Top menu > Insert > Module
- Paste the code in the big white field
- Close Microsoft Visual Basic window.
- Back to Excel hit Alt+F8 to display all macro's
- Double click RunMe to run the code and print all sheets.
And here is the code:
Best regards,
Trowa
That is a some strange limitation you have there.
See if this code works for you. It will loop through all the sheets in the workbook you run the code from.
In case you don't know how to implement the code / run the code:
- Hit Alt+F11 to open Microsoft Visual Basic window.
- Top menu > Insert > Module
- Paste the code in the big white field
- Close Microsoft Visual Basic window.
- Back to Excel hit Alt+F8 to display all macro's
- Double click RunMe to run the code and print all sheets.
And here is the code:
Sub RunMe() Dim ws As Worksheet For Each ws In Worksheets ws.PrintOut Next ws End Sub
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 12, 2014 at 11:23 AM
Aug 12, 2014 at 11:23 AM
Hi Sammysen,
What do you mean by "check print status"?
Do you want a message notifying you which sheet is being printed like:
"Hit OK to print Sheet1"
You hit OK, Sheet1 will be printed and then the next message appears:
"Hit OK to print Sheet2"
etc.
Best regards,
Trowa
What do you mean by "check print status"?
Do you want a message notifying you which sheet is being printed like:
"Hit OK to print Sheet1"
You hit OK, Sheet1 will be printed and then the next message appears:
"Hit OK to print Sheet2"
etc.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 14, 2014 at 10:16 AM
Aug 14, 2014 at 10:16 AM
Sure thing Sammysen.
You can alter the text into anything you want, but here is the code with the requested text:
Best regards,
Trowa
You can alter the text into anything you want, but here is the code with the requested text:
Sub RunMe() Dim ws As Worksheet For Each ws In Worksheets MsgBox "Kindly Print " & ws.Name ws.PrintOut Next ws End Sub
Best regards,
Trowa