Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default Protecting code in module

I have some code in a workbook module - is there a way to
limit access/edit in the module? Dealing with curious
users...

Thanks,
Phil
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default Protecting code in module

Thanks, Paul. What you've given me is many nights of
quiet rest...
-----Original Message-----
Phil, To protect the VBA project press alt and F11 to

open the VBA editor,
in the left hand window right click on your workbook name

and select VBA
project properties, protection, check lock project for

viewing and set a
password. Press Alt and Q to close this window and go

back to your workbook
and save and close the file

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can

benefit from it
** remove news from my email address to reply by email **
"Phil Hageman" wrote in message
...
I have some code in a workbook module - is there a way

to
limit access/edit in the module? Dealing with curious
users...

Thanks,
Phil



.

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
code module? Kat Excel Worksheet Functions 2 January 10th 09 03:10 AM
code won't run from a module Geoff Excel Discussion (Misc queries) 3 February 20th 07 08:08 PM
Unprotect Code Module in Code Damien Excel Discussion (Misc queries) 2 April 18th 06 03:10 PM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
copying vba code to a standard code module 1vagrowr Excel Discussion (Misc queries) 2 November 23rd 05 04:00 PM


All times are GMT +1. The time now is 01:14 PM.

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

About Us

"It's about Microsoft Excel"