Make Command Button visible only in .xlt?

[RPIJG]

Can I make it so that the command button is only visible when I open
workbook from an .xlt and not from a .xls

 

[Jan Karel Pieterse]

Hi Rpijg,

Can I make it so that the command button is only visible when I open a
workbook from an .xlt and not from a .xls?

A workbook opened from a template has an empty path property, you could
test for that:

If ActiveWorkbook.Path="" and left(Activeworkbook.name,4)><"Book" then
'Code to disable your button
Else
'Code to Enable the button
End If

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[RPIJG]

Thanks Jan