Need To Protect "Tab code"
in [Programming]
|
From: GEdwards on 31 Mar 2010 21:21 I have code within a tab, for example a "Private Sub Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it?
From: ozgrid.com on 31 Mar 2010 21:38 Protect the VBAProject http://www.ozgrid.com/VBA/protect-vba-code.htm -- Regards Dave Hawley www.ozgrid.com "GEdwards" <GEdwards(a)discussions.microsoft.com> wrote in message news:D2783F3E-DADD-4371-BD1A-3DED84D4AAE2(a)microsoft.com... >I have code within a tab, for example a "Private Sub > Worksheet_SelectionChange...". I was suprised that although I PROTECT the > worksheet with a password, the code within the tab is still accessible and > be > modified. > > How can this too be protected from anyone updating it?
From: GEdwards on 31 Mar 2010 22:20 Dave, Fantastic! You have helped me again. MANY thanks. "ozgrid.com" wrote: > Protect the VBAProject > http://www.ozgrid.com/VBA/protect-vba-code.htm > > > > -- > Regards > Dave Hawley > www.ozgrid.com > "GEdwards" <GEdwards(a)discussions.microsoft.com> wrote in message > news:D2783F3E-DADD-4371-BD1A-3DED84D4AAE2(a)microsoft.com... > >I have code within a tab, for example a "Private Sub > > Worksheet_SelectionChange...". I was suprised that although I PROTECT the > > worksheet with a password, the code within the tab is still accessible and > > be > > modified. > > > > How can this too be protected from anyone updating it? > > . >
From: Dave Peterson on 1 Apr 2010 08:12 You can protect all the code (the entire workbook's project, actually), by: Opening your workbook Open the VBE (alt-f11 is a quick way to get there) Show the project explorer (ctrl-r) Select your project Tools|VBAProject Properties|Protection tab Give it a nice (memorable!) password. Back to excel Save, close, and reopen the workbook to test. Be aware that like most passwords everywhere, there are ways of cracking it. GEdwards wrote: > > I have code within a tab, for example a "Private Sub > Worksheet_SelectionChange...". I was suprised that although I PROTECT the > worksheet with a password, the code within the tab is still accessible and be > modified. > > How can this too be protected from anyone updating it? -- Dave Peterson
|
Pages: 1 Prev: Loading Data into MultiPage UserForm Next: Macro for changing number of rows |