In MS Word I can use "Normal.dot" to recover all my special toolbars and
macros used to personalise the application's operation, if I need to reload a
clean version of Office. Is there an equivalent to "Normal.dot" in Excel,
where I also have special toolbars etc.
--
donwb

donbowyer:

That should be *.xlb for the toolbar file

Excel?.xlb


Function xlbPath() As String
Dim sLib
Dim pos
sLib = Application.StartupPath
pos = InStrRev(sLib, "\")
xlbPath = Left(sLib, pos) & _
"Excel" & IIf(Val(Application.Version) = 10,
Val(Application.Version), "") & ".xlb"
End Function

Sub test()
MsgBox xlbPath
End Sub


--

http://www.vba.com.tw/plog/


"donbowyer" wrote:

In MS Word I can use "Normal.dot" to recover all my special toolbars and
macros used to personalise the application's operation, if I need to reload a
clean version of Office. Is there an equivalent to "Normal.dot" in Excel,
where I also have special toolbars etc.
--
donwb

Many thanks chijanzen, that did it.
--
donwb


"chijanzen" wrote:

donbowyer:

That should be *.xlb for the toolbar file

Excel?.xlb


Function xlbPath() As String
Dim sLib
Dim pos
sLib = Application.StartupPath
pos = InStrRev(sLib, "\")
xlbPath = Left(sLib, pos) & _
"Excel" & IIf(Val(Application.Version) = 10,
Val(Application.Version), "") & ".xlb"
End Function

Sub test()
MsgBox xlbPath
End Sub


--

http://www.vba.com.tw/plog/


"donbowyer" wrote:

In MS Word I can use "Normal.dot" to recover all my special toolbars and
macros used to personalise the application's operation, if I need to reload a
clean version of Office. Is there an equivalent to "Normal.dot" in Excel,
where I also have special toolbars etc.
--
donwb

How do I change a landscape template into portrait template without loosing
the image? I am able to change the paper from landscape to portrait but I
loose part of the calendar.
--
Thanks, Ann


"donbowyer" wrote:

Many thanks chijanzen, that did it.
--
donwb


"chijanzen" wrote:

donbowyer:

That should be *.xlb for the toolbar file

Excel?.xlb


Function xlbPath() As String
Dim sLib
Dim pos
sLib = Application.StartupPath
pos = InStrRev(sLib, "\")
xlbPath = Left(sLib, pos) & _
"Excel" & IIf(Val(Application.Version) = 10,
Val(Application.Version), "") & ".xlb"
End Function

Sub test()
MsgBox xlbPath
End Sub


--

http://www.vba.com.tw/plog/


"donbowyer" wrote:

In MS Word I can use "Normal.dot" to recover all my special toolbars and
macros used to personalise the application's operation, if I need to reload a
clean version of Office. Is there an equivalent to "Normal.dot" in Excel,
where I also have special toolbars etc.
--
donwb