Chapter 31: Protecting Your Work
645
- Enter a password (twice).
- Click OK and then save your file. When the file is closed and then re-opened, a pass-
word will be required to view or modify the VBA code.
FIGURE 31.8Protecting a VB Project with a password.
Cross-Reference
Part VI discusses VBA macros. n
Related Topics
This section covers additional topics related to protecting and distributing your work.Saving a worksheet as a PDF file
The PDF (Portable Document Format) file format is widely used as a way to present information in
a read-only manner, with precise control over the layout. Software to display PDF files is available
from a number of sources. Excel can create PDF files, but it cannot open them.XPS is another “electronic paper” format, developed by Microsoft as an alternative to the PDF for-
mat. At this time, there is very little third-party support for the XPS format.Save a worksheet in PDF or XPS format by choosing File ➪ Save and Send ➪ Create PDF/XPS
Document ➪ Create a PDF/XPS. Excel displays its Publish as PDF Or XPS dialog box, in which
you can specify a filename and location and set some other options.