Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Save Button from toolbar
I need to check if the workbook's name is "TT.xls" - if it is, I want to remove the save button from the toolbar.
Then, what is the code to get it back? Thanks a lot, TT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Save Button from toolbar
Sub TestTT()
Dim wb As Workbook For Each wb In Workbooks MsgBox wb.Name If wb.Name = "TT.xls" Then 'commndbars().Controls().Visible = False Else 'commndbars().Controls().Visible = True End If Next wb End Sub -----Original Message----- I need to check if the workbook's name is "TT.xls" - if it is, I want to remove the save button from the toolbar. Then, what is the code to get it back? Thanks a lot, TT . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save a macro button onto a toolbar | Excel Discussion (Misc queries) | |||
How to remove customized button from toolbar? | Excel Discussion (Misc queries) | |||
Excel 2002 has no option to add the save as button to the toolbar- | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
I can't remove the Email button to the Standard toolbar in Excel | Excel Discussion (Misc queries) |