G
Guest
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)
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)