Protect Save As Atau Protect Copy Excel. To directly protect workbook from editing i think the common way is to set a modify password on. Select the cells that others can edit.
Todd goes into inga s team sharepoint site and opens the excel budget report for the latest month. In the save as type box click excel template or click excel macro enabled template if the workbook contains macros that you want to make available in the template. Set modify password to protect workbook in read only mode.
If you re using the latest version of excel you will need to press the.
To protect a worksheet go to the review tab then click protect sheet in the changes group. In your excel file select the worksheet tab that you want to protect. Open up the excel file you want to protect. Klik pada sheet atau workbook yang akan kita buka password nya biasanya posisinya seperti yang ditunjukkan oleh tanda panah dibawah ini disertai dengan judul file.
