View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Francis Ang[_3_] Francis Ang[_3_] is offline
external usenet poster
 
Posts: 75
Default protect command button

Go into visual basic design mode and select 'Tools' from the menu bar. Then
select VBAProject Properties...

Select the protection tab.

This will ensure nobody can modify your command button with the correct
password.

Hope this help.

"bill_morgan_3333" wrote:

I know how to password protect an Excel VBA project, but is there any way to
protect a worksheet command button object itself (i.e., prevent a user from
adding Visual Basic to the menu bar, clicking into VB design mode, and
moving, resizing, or deleting the command button?)

Thanks ...

Bill Morgan