Excel 2007 will not let me find and replace data in a protected - Microsoft Community

Excel 2007 will not let me find and replace data in a protected - Microsoft Community

瀏覽:1209
日期:2024-07-13
Even if your entire work has unlocked cells, when you turn protection on the Replace command will not work. If you want to use the command against a protected sheet you can do it with VBA: Sub myProtect() ActiveSheet.Protect Password:=InputBox("Enter ......看更多