makeitwork09
Technical User
Hello,
I am using Microsoft Excel 2007
I have obtained the following code to run a macro for a protected worksheet
that works as it should, I am only showing it here as a reference
In regards to rows and columns in protecting the sheet, I have been looking
for a way to protect the contents of the cells, but allow the user to
resize columns and/or rows. I know when setting up the protection the user
can be given the rights to format the column and rows, but the only
attribute I want to allow is the resizing of columns and/or rows. Is that
possible?
Thanks
I am using Microsoft Excel 2007
I have obtained the following code to run a macro for a protected worksheet
that works as it should, I am only showing it here as a reference
Code:
Private Sub Workbook_Open()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
wSheet.Protect Password:="mypassword", UserInterFaceOnly:=True
Next wSheet
End Sub
In regards to rows and columns in protecting the sheet, I have been looking
for a way to protect the contents of the cells, but allow the user to
resize columns and/or rows. I know when setting up the protection the user
can be given the rights to format the column and rows, but the only
attribute I want to allow is the resizing of columns and/or rows. Is that
possible?
Thanks