View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Bruce is offline
external usenet poster
 
Posts: 138
Default How do i password protect my VB Code from users

I would like to do a couple of things to hide / protect information in my
excel file (2k3).

1. How can I password protect my VBA so others cannot see or edit it?
2. I Have a worksheet with a command button that starts a macro but I want
to password protect the sheet. I have unlocked the cells that get the update,
but when I run the macro with protection on it says "You cannto use a macro
on a protected sheet". How can I get around this?

Bruce