Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ControlTipText on a Worksheet Button - How?
Another method would be to build a custom icon for the button. This would be a painful approach if you had a lot of buttons requiring different tips. It also has the disadvantage of being in the user's face every time they use the button and is limited in size and content but allows some...- roncurrie
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - prevent File Save and File Print
Ram, The only thing that comes to mind is that your code is not in the "this workbook" area of Excel Objects. ...Ron- roncurrie
- Post #13
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - prevent File Save and File Print
Great! I thought there might be other back doors. Hopefully there are no others. Glad you got the solution. ...Ron- roncurrie
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - prevent File Save and File Print
To disable file save and print menu items, in the "thisworkbook" area of code use the following: Private Sub Workbook_Open() Application.CommandBars("Worksheet Menu Bar").Controls.Item("File").Controls.Item("Save").Enabled = False...- roncurrie
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Err 13 Type mismatch while filling up a recordset
Bingo! I was having the same type mismatch error and by moving the you have your DAO library priorized before the ADO library in the References the problem was solved! This is a very frustrating error because it seems there is no way to track it down unless you're "in the know"- roncurrie
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
