Okay, I'm happy to say this **** Spreadsheet is almost done! Thanks to everyone here for there much needed help!
Worksheet Overview -
I have several rows for users to enter data. This populated the matching columns (duh!). Some cells need to be protected, and I need to be able to use the Outline feature at the same time. For this I the following code on the Workbook:
I also have to make it possible for them to add additional worksheets of the same content - For this I use the following code on the the Sheet:
This has been working GREAT!
The problem is apparently when you protect a sheet by using VBA, there is no easy way to enable/disable certain features for the user.
I specifically need them to have the ability to:
Select a Row
Copy said Row
Insert copied Row
Any ideas?
Worksheet Overview -
I have several rows for users to enter data. This populated the matching columns (duh!). Some cells need to be protected, and I need to be able to use the Outline feature at the same time. For this I the following code on the Workbook:
Code:
Private Sub Workbook_Open()
With ActiveSheet
.EnableOutlining = True
.Protect "password", UserInterfaceOnly:=True
End With
End Sub
I also have to make it possible for them to add additional worksheets of the same content - For this I use the following code on the the Sheet:
Code:
Private Sub Worksheet_Activate()
With Me
.EnableOutlining = True
.Protect "password", UserInterfaceOnly:=True
End With
End Sub
This has been working GREAT!
The problem is apparently when you protect a sheet by using VBA, there is no easy way to enable/disable certain features for the user.
I specifically need them to have the ability to:
Select a Row
Copy said Row
Insert copied Row
Any ideas?