Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Protecting my macros from being viewed/edited?

How can I protect my macros from being viewed/edited?
Thanks for the tips!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Protecting my macros from being viewed/edited?

In the VBE

first, rename your project from the default name VBAProject to a unique
name.

then make sure it is selected in the project explorer window so it is the
active project. Then if you go to the tools menu you will have an option

MyUniqueProjectName Properties . . .

under this selection is a tab for protecting the project. Click the lock
project for viewing and assign a password.

--
Regards,
Tom Ogilvy


wrote in message
...
How can I protect my macros from being viewed/edited?
Thanks for the tips!



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 Formulas from a range from being viewed Andrew Heath Excel Discussion (Misc queries) 4 October 12th 05 03:14 PM
Protecting My Macros Greegan Excel Worksheet Functions 1 December 4th 04 10:58 PM
Protecting Macros Anthony[_9_] Excel Programming 1 July 31st 04 10:58 AM
Protecting Macros -is it possible AlwaysAsking Excel Programming 3 June 25th 04 10:55 PM
Protecting the VB code from being viewed sameerce[_11_] Excel Programming 1 May 19th 04 03:09 PM


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