Thread: Make Command Button visible only in .xlt?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default 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

Reply With QuoteReply With Quote