kingcashandcarry
Member
lately i found that code
for some reasons i want to make a use of that and change the interface of a workbook that i use a lot at office
so i am trying to make custom navigations panels to go to sheets and toolbars and menus to run macros
but always found problems
such as
i can use drop down lists because my sheets all have different columns width
combo box form control i find many codes to run macos based selection but i cant make them work right
combobox active xcontrols in my excel meets some problems(can't insert object)
i thought to make a userform from vba and put buttons but then i had to run macro to show the userform and then make the selection.
i searched for some addon but i use a version of excel that is not work properly with that
i am in deep searching nowdays but it isn't something that i need it actually so much
if anyone has any idea and want to help i will appreciate
Code:
Sub HideExcelItems()
Application.DisplayFullScreen = True
Application.DisplayFormulaBar = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayGridlines = False
End Sub
Sub UNHideExcelItems()
Application.DisplayFullScreen = False
Application.DisplayFormulaBar = True
ActiveWindow.DisplayWorkbookTabs = True
ActiveWindow.DisplayHeadings = True
ActiveWindow.DisplayGridlines = True
End Sub
for some reasons i want to make a use of that and change the interface of a workbook that i use a lot at office
so i am trying to make custom navigations panels to go to sheets and toolbars and menus to run macros
but always found problems
such as
i can use drop down lists because my sheets all have different columns width
combo box form control i find many codes to run macos based selection but i cant make them work right
combobox active xcontrols in my excel meets some problems(can't insert object)
i thought to make a userform from vba and put buttons but then i had to run macro to show the userform and then make the selection.
i searched for some addon but i use a version of excel that is not work properly with that
i am in deep searching nowdays but it isn't something that i need it actually so much
if anyone has any idea and want to help i will appreciate
Last edited by a moderator: