Sorry I forgot to write that it won't work if you save as PDF format. If you are after a "read-only" type option for the XL file and that is why you are creating a PDF version, just password protect the workbook so that users cannot edit it but can double click the file to open it.