The situation is that I prepare an expense voucher for our staff members to fill out and submit to the office. **I removed the right click issues in the 2007 worksheet itself w/ the following: ![]() ![]() Private Sub Workbook_SheetActivate(ByVal Sh As Object)Ī(ID:=30003).Enabled = FalseĪpplication.CommandBars("Standard").FindControl(ID:=19).Enabled = FalseĪpplication.CommandBars("Standard").FindControl(ID:=21).Enabled = FalseĪpplication.CommandBars("Standard").FindControl(ID:=22).Enabled = FalseĪ(ID:=30003).Enabled = TrueĪpplication.CommandBars("Standard").FindControl(ID:=19).Enabled = TrueĪpplication.CommandBars("Standard").FindControl(ID:=21).Enabled = TrueĪpplication.CommandBars("Standard").FindControl(ID:=22).Enabled = True
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |