Make Command Button visible only in .xlt?
 

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

--
Message posted from http://www.ExcelForum.com

Make Command Button visible only in .xlt?
 

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

Make Command Button visible only in .xlt?
 

Thanks Jan


---
Message posted from http://www.ExcelForum.com/