Adnandos
New member
- Joined
- Jun 12, 2018
- Messages
- 25
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hi all
I distribute a workbook that is maintained by several people. I included a button (using vba guidance) for them to click on to export the summary tab as a pdf and email automatically to specific addresses using outlook.
It works just fine on my PC, however all the users get the same error when they try it on theirs, and the debugger points to the same line in VBA each time.
Any idea what the problem may be and how I could resolve this?
Two screenshots are attached, first one is the error.
Second one is the summary tab, my idea is that everything within the range A2:L28 should be exported as a pdf and have a feeling the print area may have something to do with it?
I distribute a workbook that is maintained by several people. I included a button (using vba guidance) for them to click on to export the summary tab as a pdf and email automatically to specific addresses using outlook.
It works just fine on my PC, however all the users get the same error when they try it on theirs, and the debugger points to the same line in VBA each time.
Any idea what the problem may be and how I could resolve this?
Two screenshots are attached, first one is the error.
Second one is the summary tab, my idea is that everything within the range A2:L28 should be exported as a pdf and have a feeling the print area may have something to do with it?
