Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lee
 
Posts: n/a
Default How can I prevent access to code contained within Tab

I have code contained within the tabs, On Activation
How can I prevent access to this code by other users.

Also how can I prevent access to the normal code ie stop access through the
Tools \ Macro selection.


Regards

Lee
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default

Hi Lee

Within the VB Editor, choose ToolsVBA Project_PropertiesProtection and set
a password for the project. Do remember to make a note of it.
Regards

Roger Govier


Lee wrote:
I have code contained within the tabs, On Activation
How can I prevent access to this code by other users.

Also how can I prevent access to the normal code ie stop access through the
Tools \ Macro selection.


Regards

Lee

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
Change case...help please Terry Excel Worksheet Functions 14 October 2nd 05 12:29 PM
Code to 'lookup' value in Access database maacmaac Excel Discussion (Misc queries) 0 September 16th 05 02:52 AM
Macro for changing text to Proper Case JPriest Excel Worksheet Functions 3 August 8th 05 09:31 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
how do i create an access code sheet to number my office files an. dana New Users to Excel 1 February 12th 05 03:49 AM


All times are GMT +1. The time now is 07:28 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"