I would like to provide a limited number of users access to a sheet containing buttons, which execute macros. I am using Protection-->Range Permissions to control who (in the network domain) can execute the buttons to run the macro. I assigned macros to Forms toolbar controls but am not sure what code will allow me to disable the buttons when the Password Protection is turned on. Help!
Private Sub PwProtectSheet()
Dim strPW As String
strPW = "password"
.EnableSelection = xlNoSelection
.Protect Password:=strPW, Contents:=True
.xlButtonControl(3).Enable = False