Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How can you hide the macros ?

How can you avoid user to look at your macros by
choosing "Visual basic editor" ?
Is there a code too protect modules, hide them ?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default How can you hide the macros ?

Josee, you can protect the VBA project, To protect the VBA project, from
your workbook right-click the workbook's icon and pick View Code. This icon
is to the left of the "File" menu this will 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 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

"Josee Lapointe" wrote in message
...
How can you avoid user to look at your macros by
choosing "Visual basic editor" ?
Is there a code too protect modules, hide them ?



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
Hide Combo Boxes with macros juancarlos Excel Discussion (Misc queries) 6 September 3rd 09 01:55 PM
Macros - Unhide and hide minka Excel Discussion (Misc queries) 2 October 22nd 06 12:25 AM
Hide worksheets if macros are disable Eintsein_mc2 Excel Discussion (Misc queries) 2 September 17th 05 07:37 PM
Conditional hide rows macros Stu[_4_] Excel Programming 1 September 25th 03 10:05 PM
Hide Macros from Users Larry Graff Excel Programming 2 September 10th 03 05:41 PM


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