| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A difficult question
Hi, I want to close all the tool boxes i an excel's workbook, but look one
line before the en sub line (Application.CommandBars("Worksheet Menu Bar").Visible = False) I can't close the menu bar, and I really need to close it, when I do this manually it closes but when I live the custimize dialog box appears again¡¡¡ What should I do???? I attach the macro: Sub Macro1() Application.CommandBars("Standard").Visible = False 'OK Application.CommandBars("Formatting").Visible = False 'OK Application.CommandBars("Stop Recording").Visible = False 'OK Application.CommandBars("Worksheet Menu Bar").Visible = False 'not woorking End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A difficult question
Application.CommandBars("Worksheet Menu Bar").Enabled = False
-- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I want to close all the tool boxes i an excel's workbook, but look one line before the en sub line (Application.CommandBars("Worksheet Menu Bar").Visible = False) I can't close the menu bar, and I really need to close it, when I do this manually it closes but when I live the custimize dialog box appears again¡¡¡ What should I do???? I attach the macro: Sub Macro1() Application.CommandBars("Standard").Visible = False 'OK Application.CommandBars("Formatting").Visible = False 'OK Application.CommandBars("Stop Recording").Visible = False 'OK Application.CommandBars("Worksheet Menu Bar").Visible = False 'not woorking End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A difficult question
you know something: you are a genius¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ¡¡¡¡¡¡¡¡¡
I have been asking the same question for month and nobody could've answer me Thaaaanksssssss "Tom Ogilvy" wrote: Application.CommandBars("Worksheet Menu Bar").Enabled = False -- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I want to close all the tool boxes i an excel's workbook, but look one line before the en sub line (Application.CommandBars("Worksheet Menu Bar").Visible = False) I can't close the menu bar, and I really need to close it, when I do this manually it closes but when I live the custimize dialog box appears again¡¡¡ What should I do???? I attach the macro: Sub Macro1() Application.CommandBars("Standard").Visible = False 'OK Application.CommandBars("Formatting").Visible = False 'OK Application.CommandBars("Stop Recording").Visible = False 'OK Application.CommandBars("Worksheet Menu Bar").Visible = False 'not woorking End Sub |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A difficult question
Not here you haven't!
-- HTH RP (remove nothere from the email address if mailing direct) "filo666" wrote in message ... you know something: you are a genius¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ I have been asking the same question for month and nobody could've answer me Thaaaanksssssss "Tom Ogilvy" wrote: Application.CommandBars("Worksheet Menu Bar").Enabled = False -- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I want to close all the tool boxes i an excel's workbook, but look one line before the en sub line (Application.CommandBars("Worksheet Menu Bar").Visible = False) I can't close the menu bar, and I really need to close it, when I do this manually it closes but when I live the custimize dialog box appears again¡¡¡ What should I do???? I attach the macro: Sub Macro1() Application.CommandBars("Standard").Visible = False 'OK Application.CommandBars("Formatting").Visible = False 'OK Application.CommandBars("Stop Recording").Visible = False 'OK Application.CommandBars("Worksheet Menu Bar").Visible = False 'not woorking End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult formula question | Excel Worksheet Functions | |||
| difficult formula question | Excel Worksheet Functions | |||
| Graph question - difficult? | Excel Discussion (Misc queries) | |||
| Difficult ------------- question | Excel Discussion (Misc queries) | |||
| difficult question | Excel Discussion (Misc queries) | |||
Linear Mode
