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

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/