Help with Excel

August 7th, 2016

Dear All,
i had a Excel with bluid list of user,
when i click pick up a user it shows up a list of users.
something happens lately when i click now on it nothing happens.
is it some feature to turn or or off ?
please advise ?
attached is a excel picture
thank you so much
http://postimg.org/image/va1dhdz3x/ when i go to the Developer mode and click on run script it’s open fine.
any suggestions why its not clickable anymore?
thank you

Answer #1
The button has code behind it. Are macros enabled? If they aren’t, the code will not run.
The other thing I can think of is that the range of where you have your user list has changed. So if you inserted an additional column on the worksheet with the users, the code would have to be manually changed. This is of course, assuming that the code uses a range on a worksheet rather than having them hard-coded.
Answer #2
Thank you sir.
i just checked the Macro is enabled.
someone has made this for me and dont know how to check if the code has been changed or not.
are you able to help me on this please ?

 

| Sitemap |