Working on an Excel document that has several password-protected tabs (i.e. worksheets). These "protected" tabs include working macros with code that effectively unprotects the tab, runs the macro, and then re-protects the tab before exiting.
Here's a sample:
_________________
Sub sort()
'
' sort Macro
' Macro recorded 12/15/02 by Administrator
'
' Keyboard Shortcut: Ctrl+p
'
ActiveSheet.Unprotect Password:="1234"
Range("C3:D23").Select
ActiveWindow.LargeScroll Down:=-2
Selection.sort Key1:=Range("c3"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveSheet.Protect Password:="1234"
End Sub
_________________
If possible, I'd like to HIDE the 2 lines of code above that make reference to the password. Is there any way to change a line of code's text color to match the background color, thereby making the line invisible to the reader?
Appreciate any suggestions here.
Thank you.
- Kevon
Bookmarks