Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make Command Button visible only in .xlt?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button to make multiple duplicate worksheets | Excel Worksheet Functions | |||
How to make Ms Excel more Excel with Command Button and progress b | Excel Discussion (Misc queries) | |||
Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |