Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB to protect cells not working in Excel 2003?
I have a spreadsheet we send to numerous vendors that has all the formula
cells protected. We just received a file back from a vendor with incorrect formulas in it that the vendor should not have been able to change. I'm reasonably sure the file went to the vendor protected, and I'm trying to figure out what happened. The file was created in Excel 2002 and works fine in Excel 2000. The vendor has Excel 2003 which I don't have access to for testing, and I'm wondering if the protection does not work in the newer Excel version. I've included the code below. Thanks for any help on this. Sheets("Period 1").Select ActiveSheet.Unprotect Password:="vendorprotect" Cells.Select Selection.SpecialCells(xlCellTypeFormulas, 23).Select Selection.Locked = True 'Unprotect Weeks Performance and Plan Units Range("T7:T120").Select Selection.Locked = False Selection.FormulaHidden = False Range("V7:V120").Select Selection.Locked = False Selection.FormulaHidden = False Range("A1").Select ActiveSheet.Protect Password:="vendorprotect", DrawingObjects:=True, Contents:=True, Scenarios:=True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 won't let me click on a button when i protect document | Excel Discussion (Misc queries) | |||
Excel 2003 Protect file from being deleted | Excel Discussion (Misc queries) | |||
how to totally protect data excel 2003 | Excel Discussion (Misc queries) | |||
Can't protect some cells in Excel 2003 | Excel Discussion (Misc queries) | |||
Macro working in Excel 2003; not working in Excel 2000 | Excel Programming |