I'm working in Excel 2010. I'd like users of this particular
spreadsheet to be able to 'Save as PDF', but I do not want users to
be able to use 'Save' or 'Save as'.

Is there a code for this?

Thanks in advance for any help.

BD

You can use the Workbook_BeforeSave event to 'trap' people trying to
use Save/SaveAs, set Cancel=True, then use the ExportAsFixedFormat
method for the worksheet/workbook as suits your need. Easiest way to
get code for this is to go through the steps manually while the macro
recorder is running, clean up the 'junk' that the recorder so
generously donates, and put code in the Workbook_BeforeSave event to
'Call' the macro.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion