LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VB password protection??

I have a macro that unprotects my workbook, unhides sheets and updates data from external files, then rehides the sheets and reprotects the workbook. I would like users not to be able to just edit the macro to get the password. I have seen several posts suggesting that others lock the VBA project from viewing and set a password. Is there anything else that needs to be done after that to actually have the protection take effect? I went in and set a password and locked the project for viewing but then I was still able to edit the macro and see the password that protects the workbook. Am I missing something??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password protection in macro ( Anybody can view my password in VB Sherees Excel Discussion (Misc queries) 2 January 24th 10 10:05 PM
Excel Data Protection- AKA: Sheet/Macro Password Protection Mushman(Woof!) Setting up and Configuration of Excel 0 December 29th 09 06:50 AM
Password Protection Duncan, UK Excel Discussion (Misc queries) 2 September 18th 06 04:37 PM
Password Protection sylvia Excel Discussion (Misc queries) 1 December 2nd 05 04:15 PM
Password protection series0 Excel Programming 1 February 12th 04 01:10 AM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"