Disable Command Button when File name begins with Customer?

  • Thread starter Thread starter RPIJG
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YouTube error: "If playback doesn't begin shortly, try restarting your device" 0
How to call Excel add-in macro from a button… 1
Add Current date and time when pressing a command button 2
disable macros in a worksheet 5
Client Access File Transfer from Excel 2010 4
Disabling Custom Command Bar Button when using Formula Bar 1
Command Button to import worksheets 1
help with vba and command button 5

Back
Top