Paste special button

  • Thread starter Thread starter Sylvain
  • Start date Start date
S

Sylvain

I had a paste button which provided the possibility of
choosing the paste option (such as values or format) thus
saving me from the need to access the "paste
special"function. That button disappeared in a crash some
time back and is not available in the "customize"
function.
On opening Excel today the system proposed an opening
in "safe mode". To my surprise, my sheet opened with all
the fuctionalities I has before the crash, including the
button.
Can anyone help me both on how to use the "safe mode"
option to recover ALL my previous settings and locate
that button in case I lose it again
 
Sylvain,

Try this macro to add that button to your standard commandbar:

Sub AddPasteSpecial()
Application.CommandBars("Standard").Controls.Add _
Type:=msoControlButton, ID:=755
End Sub

HTH,
Bernie
 
Back
Top