Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protecting excel sheet for data input
Dear All:
I am using Excel for inputting data as part of a larger application. Each worksheet roughly corresponds to a table for user input. Each table has a predefined number of columns, the rest of the columns in the worksheet are not being used and can be hidden from the user. My concern is about the data area of the worksheet, which I am not protecting in any way because I want the user to be able to modify the data at will. During this process, the user may, for example, accidentally delete a useful table column. So I am looking for a way to at least prevent column deletion while allowing data input/editing functions. Also, the data area of the worksheet contains defined names. How can I protect these from deletion as well? TIA for all suggestions, Nikolas ps. I will be using VBA to implement protection of the data table |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protecting excel sheet for data input
A simple password protection applied to all sheets might be enough?
Sub protectsheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="Password" Next End Sub Sub unprotectsheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Unprotect ("Password") Next End Sub -- Cheers Nigel "rdrnws" wrote in message ... Dear All: I am using Excel for inputting data as part of a larger application. Each worksheet roughly corresponds to a table for user input. Each table has a predefined number of columns, the rest of the columns in the worksheet are not being used and can be hidden from the user. My concern is about the data area of the worksheet, which I am not protecting in any way because I want the user to be able to modify the data at will. During this process, the user may, for example, accidentally delete a useful table column. So I am looking for a way to at least prevent column deletion while allowing data input/editing functions. Also, the data area of the worksheet contains defined names. How can I protect these from deletion as well? TIA for all suggestions, Nikolas ps. I will be using VBA to implement protection of the data table |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can 7 workers input Excel data into a Master Sheet? | Excel Discussion (Misc queries) | |||
password protecting a column for data entry in a sheet, how? | Excel Worksheet Functions | |||
Moving data in one excel column to another sheet based on user input | Excel Discussion (Misc queries) | |||
Protecting excel sheet for data input | Excel Discussion (Misc queries) | |||
Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) |