Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi, I have a workbook that works under "allmost" FullScreen. On opening it, or Activate, is "throws out" (hides) all the toolbars with: ' Dimension a loop variable. Dim i As Integer ' Loop through the total number of toolbars. For i = 1 To Application.Toolbars.Count ' Hide each toolbar. Application.Toolbars(i).Visible = False ' End of loop. Next i Only The Menu bar remains. Now, when Closing (or Deactivate) this workbook I want to restore some toolbars. Application.DisplayFormulaBar = True Application.DisplayStatusBar = True works just fine for the Formula and Status bars. But I can't manage the Standard/Formatting/Drawing bars. I think the problem is because I work with the Portuguese XP version. Drawing = "Desenho" / Standard = "Padrao" etc. But even using these terms doesn't resolve. And anyway, I want that even with XP in Swahili my workbook can be used. Question: Must I use int. ID codes for these bars ?? Regards S.Krol ![]() -- skrol ------------------------------------------------------------------------ skrol's Profile: http://www.excelforum.com/member.php...o&userid=27126 View this thread: http://www.excelforum.com/showthread...hreadid=470450 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box enable and disable | Excel Worksheet Functions | |||
enable/disable macro | Excel Discussion (Misc queries) | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
Enable/Disable macros | Excel Discussion (Misc queries) | |||
Enable toolbars at close | Excel Programming |