Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PSW for Macro & Codes
Peter,
What you gave me is the final part. What I need is to add a password in the code so that the user cannot unprotect the sheets. Then I will use the function you described to hide the password in the code. Thanks Alex "Peter Beach" wrote in message ... Hi Alex, If by PSW you mean "password", go to the Project Explorer (normally docked to the left-hand side of the screen) and right click with the mouse on the VBA Project item and select Properties. A window will pop up, go to the Protection Tab and set your password and enable protection. HTH Peter Beach <snip I want to add a PSW to avoid that the users do mistakes or changes in the WS What is the code I can use to add the PSW and where shall I place it? My intention is to use the VBA project properties to hide the PSW. Thank you Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro codes | Excel Discussion (Misc queries) | |||
Need some macro codes | Excel Discussion (Misc queries) | |||
codes, codes, codes... | Excel Discussion (Misc queries) | |||
Help with codes please!! | Excel Discussion (Misc queries) | |||
hiding macro codes upon protecting the worksheet | Excel Discussion (Misc queries) |