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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Set a formula in Excel via VBA
Hello, I'll bet that you are having difficulty due to the quotation marks (I think you need to double them in the macro). I'd recommend that you use the Record Macro function and manually type the formula into the cells. Cut and paste this "Recorded" formula into your macro. This...- msinclair
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Disable or Hide Excel Menu Bar
Hello: The following formats should help you . . . Main Menu Bar Disable: Application.CommandBars("Worksheet Menu Bar").Enabled = False Items in Menu Disable: Application.CommandBars("Insert").Controls.Item(2).Enabled = False Remember to give yourself a means of...- msinclair
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
