Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock macros in Excel

Status
Not open for further replies.
jenwalton

jenwalton

Technical User
Oct 25, 2001
7
US
Is it possible to lock macros in Excel - I have one saved in a workbook and want to apply a password (not to the whole file, just the macro) in order for another user to view or especially, edit, the macro.

Any help or advice you could give would be much appreciated.

Thanks!!
 
Sort by date Sort by votes
In the VB editor, right-click on your project in the project explorer window, and choose "VBA Project Properties". On the "Protection" tab, you can set a password for viewing (and therefore, editing) the VBA code.
Rob
[flowerface]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
899
mikrom
mikrom
2009luca
  • Question
put value in input box web page
Replies
0
Views
202
2009luca
2009luca
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
597
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top