excel设置了只读如何更改

1.Excel只读密码如何设置与修改?

使用Excel来编辑工作表文档，有时候数据需要保密，可以在Excel表格数据文档上设置只读密码或者修改密码。

设置方法如下： 在Excel2007中点击左上角的按钮，在弹出菜单中选择另存为。或者按快捷键F12也是一样的效果。

常规选项 在另存为界面左下角有一个工具按钮，点击工具按钮右边的小三角，在弹出菜单中选择常规选项。 这时我们就可以在常规选项中设置密码了。

设置打开权限密码后，他人可以用这个密码阅读这个Excel文件。设置修改权限密码后，他人可以用这个密码打开和修改这个Excel文件。

勾选建议只读后，他人在试图打开Excel文件的时候，会弹出建议只读的提示窗口。 PS：在Excel2000和Excel2003版本中为文件设置密码也是类似的方法，只是界面稍有差别，在另存为界面中工具是在右上角。

在Excel2007上编辑文档并将其设置只读密码，这样，别人要想查看Excel文档就必须输入密码，而且还不能修改文档中的数据。 而Excel2007的设置方法与之前版本会更加简单些，只要在常规选项中设置密码就可以了。

以上是我对于这个问题的解答，希望能够帮到大家。

2.极速office2017打开密码保护的Excel为什么编辑不了

1、打开Excel表格中的Excel选项，选择自定义，得到如下画面：2、然后在左边侧框栏中选择“查看宏”之后双击或者选择添加按钮，则可以看到右边栏中有了查看宏按钮，之后点击右下角的确定。

3、大家可以在下面这个窗口处看到箭头所指的按钮：点击按钮，之后弹出窗口： 4、在宏名处填写一个名字（可随意），然后点击创建，弹出以下窗口： 5、将窗口内的内容全选后删除，然后将下面分割线以内的内容开始复制粘贴在上面的窗口内：从横线下开始复制------------------------------------------------------------------------------------------Option Explicit Public Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords。 Bob McCormick' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passwords'' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1。

1)' Modified 2003-Apr-04 by JEM: All msgs to constants, and' eliminate one Exit Sub (Version 1。1。

1)' Reveals hashed passwords NOT original passwordsConst DBLSPACE As String = vbNewLine & vbNewLineConst AUTHORS As String = DBLSPACE & vbNewLine & _"Adapted from Bob McCormick base code by" & _"Norman Harker and JE McGimpsey"Const HEADER As String = "AllInternalPasswords User Message"Const VERSION As String = DBLSPACE & "Version 1。 1。

1 2003-Apr-04"Const REPBACK As String = DBLSPACE & "Please report failure " & _"to the microsoft。 public。

excel。programming newsgroup。

"Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _"now be free of all password protection, so make sure you:" & _DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _DBLSPACE & "Also, remember that the password was " & _"put there for a reason。 Don't stuff up crucial formulas " & _"or data。

" & DBLSPACE & "Access and use of some data " & _"may be an offense。 If in doubt, don't。

"Const MSGNOPWORDS1 As String = "There were no passwords on " & _"sheets, or workbook structure or windows。 " & AUTHORS & VERSIONConst MSGNOPWORDS2 As String = "There was no protection to " & _"workbook structure or windows。

" & DBLSPACE & _"Proceeding to unprotect sheets。" & AUTHORS & VERSIONConst MSGTAKETIME As String = "After pressing OK button this " & _"will take some time。

" & DBLSPACE & "Amount of time " & _"depends on how many different passwords, the " & _"passwords, and your computer's specification。 " & DBLSPACE & _"Just be patient! Make me a coffee!" & AUTHORS & VERSIONConst MSGPWORDFOUND1 As String = "You had a Worksheet " & _"Structure or Windows Password set。

" & DBLSPACE & _"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _"Note it down for potential future use in other workbooks by " & _"the same person who set this password。 " & DBLSPACE & _"Now to check and clear other passwords。

" & AUTHORS & VERSIONConst MSGPWORDFOUND2 As String = "You had a Worksheet " & _"password set。 " & DBLSPACE & "The password found was: " & _DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _"future use in other workbooks by same person who " & _"set this password。

" & DBLSPACE & "Now to check and clear " & _"other passwords。" & AUTHORS & VERSIONConst MSGONLYONE As String = "Only structure / windows " & _"protected with the password that was just found。

" & _ALLCLEAR & AUTHORS & VERSION & REPBACKDim w1 As Worksheet, w2 As WorksheetDim i As Integer, j As Integer, k As Integer, l As IntegerDim m As Integer, n As Integer, i1 As Integer, i2 As IntegerDim i3 As Integer, i4 As Integer, i5 As Integer, i6 As IntegerDim PWord1 As StringDim ShTag As Boolean, WinTag As Boolean Application。 ScreenUpdating = FalseWith ActiveWorkbookWinTag = 。

ProtectStructure Or 。ProtectWindowsEnd WithShTag = FalseFor Each w1 In WorksheetsShTag = ShTag Or w1。

ProtectContentsNext w1If Not ShTag And Not WinTag ThenMsgBox MSGNOPWORDS1, vbInformation, HEADERExit SubEnd IfMsgBox MSGTAKETIME, vbInformation, HEADERIf Not WinTag ThenMsgBox MSGNOPWORDS2, vbInformation, HEADERElseOn Error Resume NextDo 'dummy do loopFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i。

3.如何让一个“只读”的Excel文档可以更改

点击窗口左上角的office按钮，选择“另存为”，在“保存文档副本”选项中单击“excel工作簿”；

2.在“另存为”对话框中，单击窗口左下角的“工具”，在弹出的选项框中选择“常规选项”；

3.在弹出的“常规选项”对话框中输入修改权限密码，然后点击”确定按钮；

提示：如果设置了“打开权限密码”，在下次打开该文档时会弹出对话框，提示输入打开文档所需密码。

4.在“确认密码”对话框中再次输入修改权限密码，点击“确定”；

5.选择保存位置，这里选择桌面。最后单击“保存”按钮。文档的只读密码就设置好了。

设置“修改权限密码”设置密码，再把其下方的“建议只读”勾选上。这样别人可以不输入密码进入文档，改动后不能保存原文档，只能保存备份的，不会伤及你的原文档。

Excel电子表格，Excel是微软公司出品的Office系列办公软件中的一个组件，Excel的中文含义就是“超越”。确切地说，它是一个电子表格软件，可以用来制作电子表格、完成许多复杂的数据运算，进行数据的分析和预测并且具有强大的制作图表的功能。