View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default 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