S
StargateFanFromWork
I've been using this neat new code given to me last week for "protecting" a
sheet yet allowing vb functions to work:
*****************************************************************************************************
With ActiveSheet
.EnableAutoFilter = True
.Protect UserInterfaceOnly:=True
End With
*****************************************************************************************************
This does, indeed, do the job.
I have a new workbook that needs adjusting that doesn't have a bunch of
commandbar code, etc., so I can just add an Auto_Open with the above code
in. But this just needs to be applied to "sheet2". Can someone kindly pls
provide the code for "sheet2" vs "ActiveSheet"?
Thanks. D
sheet yet allowing vb functions to work:
*****************************************************************************************************
With ActiveSheet
.EnableAutoFilter = True
.Protect UserInterfaceOnly:=True
End With
*****************************************************************************************************
This does, indeed, do the job.
I have a new workbook that needs adjusting that doesn't have a bunch of
commandbar code, etc., so I can just add an Auto_Open with the above code
in. But this just needs to be applied to "sheet2". Can someone kindly pls
provide the code for "sheet2" vs "ActiveSheet"?
Thanks. D