Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default protecting macro code

Irishmaninusa,

From the VBA Editor:
Tools/VBA Project Properties
Select the "Protection" tab
Check "Lock Project for Viewing"
Enter the passwords.

Note: An experienced user can circumvent any
passwords if they so desire (including this one).

John

Irishmaninusa wrote:

Hi Everyone,

Is there a way to protect a macro from being changed by people who should
not be changing the way the macro works?

--
J.Daly
structuinteractive
Ph: 616-364-7423
Fx: 616-364-6941

http://www.structureinteractive.com


Reply
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
Protecting a macro NZuser Excel Discussion (Misc queries) 4 April 10th 09 07:06 AM
Protecting Code in Visual Basic Editor (Excel 2003) Johnny S. NH Excel Worksheet Functions 1 August 30th 08 07:26 AM
Protecting a macro DannyS Excel Discussion (Misc queries) 4 September 5th 07 02:38 PM
Does protecting a workbook shut off VBA code? Stilla Excel Worksheet Functions 1 May 12th 06 08:34 AM
macro for Protecting a Sheet cincode5 Excel Discussion (Misc queries) 5 July 20th 05 11:59 AM


All times are GMT +1. The time now is 03:19 AM.

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"