Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Command Button when File name begins with Customer?
I want to put something into the workbook that disables the comman
button when the filename begins with the word customer...can I do this -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Command Button when File name begins with Customer?
Yes. At the start of your code for the button (which I assume finds a file)
add the following... If Left('filename', 8) = "Customer" then Exit Sub HTH, Greg "RPIJG " wrote in message ... I want to put something into the workbook that disables the command button when the filename begins with the word customer...can I do this? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I disable the delete command for a file | Excel Discussion (Misc queries) | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
Can I disable the Save command for an Excel file? | Excel Discussion (Misc queries) | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
How I disable a command button until cell has value? | Excel Programming |