Ravi Shankar

Tweaking Apps

Read-only

How to make a workbook read only in Excel

By Leave a Comment

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010

Click on the File menu –> Info menu

Protect Workbook in Excel 2013 and Excel 2010

Click on the Protect Workbook drop down arrow. This would display the following menu list

Mark workbook as final in Excel 2013 and Excel 2010

Click on the Mark as Final menu, the following dialog box would appear.

image

On selecting OK button the following confirmation box will be displayed.

Warning message when workbook marked as final in edited

By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file.

Also See: Different ways to protect workbook in Excel 2013

How to make a read only presentation in PowerPoint

By Leave a Comment

PowerPoint in Office 2010 and Office 2013 can be marked as final and let readers know the presentation is final and make it read-only by using the PowerPoint Info menu features. This would provide users with warning message when editing and making changes to the PPT slides.

Author has marked the presenation as final

Listed below are the steps to mark a presentation as final in PowerPoint 2010 and PowerPoint 2013.

  • Click on File menu –> Navigate to menu
  • Click on the Protect Presentation and select Mark as Final from list of menus.

Mark as Final in PowerPoint 2010 and PowerPoint 2013

  • The following dialog box would be displayed. Click Ok to continue.

This presenation will be marked as Final and Saved

  • The following warning message would also be displayed. Click ok to complete the operation.

image

This would make the PowerPoint Presentation as a read-only.

Prevent users from making changes to Presentation

If you do not want users to make any changes to PowerPoint presentation then you can save the PowerPoint as PowerPoint Show (*.ppsx). Listed below are the steps to save the presentation as PowerPoint Show in PowerPoint 2010 and PowerPoint 2013

Click File menu and select Save As option from the menu list.

Save As PowerPoint 2013 and PowerPoint 2010

Now double click on the Computer to launch Save As dialog box.

PowerPoint Show

Enter a name for the presentation and select PowerPoint Show in Save as type dropdown. Then click the Save button to the convert the file in to PowerPoint Show file format. Now users can run this file as PowerPoint presentation and will not be able to make any changes to it.

Also See: Create customs views to show only unread messages in Outlook 2013