mike.schultz
Board Regular
- Joined
- Sep 22, 2002
- Messages
- 57
I need to disable other users from being able to sort my spreadsheet, while still having read/write access to the sheet. I currently am using this code to disable the user from using the sort option from the worksheet menu bar, but this still allows the user to use any buttons in the standard tool bar. (need to turn both on and or off when closing the sheet.)
With Application.CommandBars("data")
.Controls.Item("Sort...").Enabled = False
End With
With Application.CommandBars("data")
.Controls.Item("Sort...").Enabled = False
End With