Templates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Many thanks chijanzen, that did it.
--
donwb


chijanzen said:
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
Click to expand...
 
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.
 
Back
Top