| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Keep custom toolbar settings - Help!!
I have created an excel workbook where the only toolbar displayed is one
which I have created. I have attached this toolbar to the workbook already. However, my question is when I close this workbook and open a completly new Excel workbook, it has kept those original settings from the previous workbook. All the custom toolbars, Formula, Standard etc remain hidden. How can I change this so that only my created workbook keeps my personal settings Any help for a novice??? thanks in advance Anthony |
|
#2
|
|||
|
|||
|
If your workbook turns off those toolbars when you open it, your workbook should
return them to the way the user had them when that workbook closes. You do have code to hide/disable those toolbars, right? Anthony wrote: I have created an excel workbook where the only toolbar displayed is one which I have created. I have attached this toolbar to the workbook already. However, my question is when I close this workbook and open a completly new Excel workbook, it has kept those original settings from the previous workbook. All the custom toolbars, Formula, Standard etc remain hidden. How can I change this so that only my created workbook keeps my personal settings Any help for a novice??? thanks in advance Anthony -- Dave Peterson |
|
#3
|
|||
|
|||
|
Dave,
Thanks ur reply - my answer is ...er nope !! I assume this is bad?? hope you can help further Anthony "Dave Peterson" wrote: If your workbook turns off those toolbars when you open it, your workbook should return them to the way the user had them when that workbook closes. You do have code to hide/disable those toolbars, right? Anthony wrote: I have created an excel workbook where the only toolbar displayed is one which I have created. I have attached this toolbar to the workbook already. However, my question is when I close this workbook and open a completly new Excel workbook, it has kept those original settings from the previous workbook. All the custom toolbars, Formula, Standard etc remain hidden. How can I change this so that only my created workbook keeps my personal settings Any help for a novice??? thanks in advance Anthony -- Dave Peterson |
|
#4
|
|||
|
|||
|
How do the other toolbars disappear?
Anthony wrote: Dave, Thanks ur reply - my answer is ...er nope !! I assume this is bad?? hope you can help further Anthony "Dave Peterson" wrote: If your workbook turns off those toolbars when you open it, your workbook should return them to the way the user had them when that workbook closes. You do have code to hide/disable those toolbars, right? Anthony wrote: I have created an excel workbook where the only toolbar displayed is one which I have created. I have attached this toolbar to the workbook already. However, my question is when I close this workbook and open a completly new Excel workbook, it has kept those original settings from the previous workbook. All the custom toolbars, Formula, Standard etc remain hidden. How can I change this so that only my created workbook keeps my personal settings Any help for a novice??? thanks in advance Anthony -- Dave Peterson -- Dave Peterson |
|
#5
|
|||
|
|||
|
Anthony
See some references to websites for creating "on the fly" menu items and Toolbars over in your other post at worksheet.functions. Gord Dibben Excel MVP On Fri, 25 Feb 2005 16:09:03 -0800, "Anthony" wrote: Dave, Thanks ur reply - my answer is ...er nope !! I assume this is bad?? hope you can help further Anthony "Dave Peterson" wrote: If your workbook turns off those toolbars when you open it, your workbook should return them to the way the user had them when that workbook closes. You do have code to hide/disable those toolbars, right? Anthony wrote: I have created an excel workbook where the only toolbar displayed is one which I have created. I have attached this toolbar to the workbook already. However, my question is when I close this workbook and open a completly new Excel workbook, it has kept those original settings from the previous workbook. All the custom toolbars, Formula, Standard etc remain hidden. How can I change this so that only my created workbook keeps my personal settings Any help for a novice??? thanks in advance Anthony -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom toolbar not saved | Excel Discussion (Misc queries) | |||
| Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
| custom toolbar w/ macro | Excel Discussion (Misc queries) | |||
| I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
| Add custom Worksheet and Toolbar in shared drive | Excel Discussion (Misc queries) | |||
Linear Mode
