View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Cain Ryan Cain is offline
external usenet poster
 
Posts: 2
Default vba pw prompt undesired for end users

I have an Excel 2000 workbook which I password protected the vba code. Some
people are telling me when they open my workbook and try and use it by
clicking on the command buttons I programmed, they are prompted for a
password. Normally, the workbook should open and ask them if they want to
enable macros, which they should say yes for my application and then the
application would run. What do I need to do so users can use the workbook
without being prompted for a password upon clicking on one of my programmed
command buttons?