View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Koppel Greg Koppel is offline
external usenet poster
 
Posts: 79
Default 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/