Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to create a button on my custom "standard" toolbar that would
toggle the formula bar on and off. I can't seem to get to that specific feature by using "add or remove buttons"; Perhaps is there a way to sendkeys"Alt T,O,F" ? I would prefer to not have to make a macro for this so security settings/enabling macros would not be required... If I have to make the button call this macro... Sub toggleFormulabar() If Application.DisplayFormulaBar = False Then Application.DisplayFormulaBar = True Else Application.DisplayFormulaBar = False End If End Sub 1) Where do I put this so that any spread sheet I open will have this feature (just like they have my custom toolbars pre-loaded). 2) Can I make it so that any machine that opens one of my spreadsheets from a network drive will have this feature? Will they have to lower their security setting? (barring digital signatures and trusting me as a source) -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code to Create a Toggle Button | Excel Programming | |||
Toggle Button | Excel Programming | |||
Adding .xla button for Toggle Calculation Button | Excel Programming | |||
How to create a toggle button on the menu? | Excel Programming | |||
Toggle Button | Excel Programming |