Create PDF in Ecel 2010

[joehjas]

The situation I have on my hands is over 200 users, were the majority can't use Excel's built in function to create PDF's.
Yes, I've tried to teach them, but I'm probably not a good teacher.

So, I've resorted to create a button at the top of the worksheet, that says "Create PDF".
I thought this was gonna be very easy to program, but alas.

Is there a way to start the built-in Excel dialog that happens when you click "Create PDF/XPS" in "Save & Send"?

[Andy Pope]

Please Login or Register  to view this content.

Rather than a button you could explain to them how to add the "Publish as PDF or XPS" to the QAT.
Or create an addin that adds a button to the ribbon

[joehjas]

Please Login or Register  to view this content.

Rather than a button you could explain to them how to add the "Publish as PDF or XPS" to the QAT.
Or create an addin that adds a button to the ribbon

It has to be simpler than that, most of the users are carpenters, masons or craftsmen and have very little experience with excel.
So unless it's RIGHT in front of them, it's too hard.

[Andy Pope]

lets hope they don't manage to scroll the sheet and have the button vanish

[joehjas]

lets hope they don't manage to scroll the sheet and have the button vanish

Indeed