| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect
Hi, I am trying to protect data driven by VBA in Columns A:I and L2:P20 but
want the user to be able to make calculations on the tab as well. I was using this: ws.Protect "Sheet1", UserInterfaceonly:=True but I'm not sure how to edit it to protect a range of data? Can anyone help? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect
With stuff like this, I find it easiest to record a macro when I do it
manually. Then I have the syntax and I can tweak it for what I need. You may want to try that. bg wrote: Hi, I am trying to protect data driven by VBA in Columns A:I and L2:P20 but want the user to be able to make calculations on the tab as well. I was using this: ws.Protect "Sheet1", UserInterfaceonly:=True but I'm not sure how to edit it to protect a range of data? Can anyone help? Thanks in advance! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Protect UserInterface VS Protect/Unprotect | Excel Programming | |||
| Disable Tools, Protect, Protect Workbook | Excel Programming | |||
| Lock and protect cells without protect the sheet | Excel Programming | |||
Linear Mode
