Disable Command Button when File name begins with Customer?

R

RPIJG

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
 
G

Greg Koppel

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
 
Top