Protect The VBA Of Workbook

Mar 27, 2009

I have created an Excel workbook and protected the sheet. However, it still allows me go into the VBA section (Alt+F11) and edit away to their heart's content.

How can I protect my spreadsheet, as well as the VBA associated with it?

View 4 Replies


ADVERTISEMENT

Locking Workbook :: Tools >protection > Protect Workbook

Jan 21, 2008

I have a workbook with 8 sheets. I have hidden two of the sheets and want to lock the rest from people editing, and stop them from unhiding the hidden sheets

I go to tools>protection > protect workbook

After typing in the password this doesnt protect the workbook as i am still able to edit the cells.

how to lock the all sheets and stop them from being edited?

View 9 Replies View Related

Protect Workbook

Jan 19, 2009

Is there a button to protect a workbook in the same way that you can protect sheets? For example, I don't want a user to be able to touch any locked cells and there's multiple worksheets in this workbook. Do I have to go to each worksheet and protect them or is there a button to protect all worksheets at once?

View 3 Replies View Related

Protect The Workbook

Feb 15, 2010

Excel 2007. I have the workbook structure protected with a password. When I open the file, the worksheets are sized to file the normal Excel window space. When I email the spreadsheet to a customer who also has Excel 2007, the worksheets are small and she has to use the arrows to navigate.

We tried changing her view and that didn't work. She does not have the arrows available to resize the window. The only way I could fix it for her was to remove the workbook structure protection. I'm nervous about leaving it this way for our entire customer base as they could unhide hidden sheets and even delete them. Has anyone else experienced this? One more thing, customers that have an earlier version of Excel have not had this problem. This workbook is save as an .xls to be backward compatible.

View 9 Replies View Related

Protect Workbook From Ex-employees

Sep 19, 2008

How can I protect by workbook from ex-employees and the competition from using (I am aware of the weak security measures Excel offers, but something is better than nothing)? Each worksheet is password protected to slow down novice Excel users. However, ex-employees know the password. I was thinking if there was a way to have a changing password (which only a couple people would know) or have the worksheet look for a hidden file on our network, that one of these methods (or another) might work.

View 6 Replies View Related

Protect The Formatting Of Workbook?

Jun 28, 2013

I'm trying to protect my workbook from having people around the office from changing the formatting -- I need standard fonts, outline on the cells, etc. Is there a way for me to protect the formatting, but still keep the cells open and editable for new and updated information?

View 1 Replies View Related

Protect Workbook No Password

Jan 11, 2010

I have a workbook that contains a series of macros designed to compare various reports and spit out a report. I don't want my users to have to insert a password, but I want to keep my workbook protected. I've already protected the macros in the VBA Properties, so those are pretty safe, but the worksheets in the workbook are susceptible to changes that will hose my macros.

Setting the workbook to "Read Only" in Properties on our shared drive helps, but any user can change that at will. Within Excel, going to Options, Security, I can set a password so no-one can modify that workbook, but that pops up a password box when they open the workbook. I'd like to NOT have the password box pop up unless I need to make changes. Is there a way to do that? I've looked on the internet but can't find a solution on this one.

View 5 Replies View Related

How Do I Protect An Entire Workbook

Dec 13, 2006

How do I protect an entire workbook, rather than each worksheet, individually?

Also, I have several worksheets in this workbook. When info is entered in b8, I want this info automatically inserted in all other worksheets within that workbook.

View 9 Replies View Related

How To Protect Multiple Sheets In Workbook

Jun 19, 2006

How to protect multiple sheets in a workbook and not having to protect them 1 by 1. I have copied and pasted all the different macro's/visual basic script that has been posted for that purpose, but I can't get it to work and I'm always getting an error. The error from visual basic says "compile error: invalid outside procedure" and then the visual basic screen shows the following:

Range ("AM52")
If Ans >= 0 Then
"+."

It does not like the "AM52" part because it is highlighted in the error message.

Also, the error I get from recording my own macro step by step is "Run time error 40036" from visual basic.

View 8 Replies View Related

Protect And Hide Sheet In Workbook?

Apr 26, 2009

I've stored all my on-line passwords (about 50 of them) in one sheet in an Excel workbook. I want to protect it so that if somebody somehow got access to it, they couldn't see the sheet, much less change anything.

I tried Tools/Protection/Protect Sheet and Tools/Protection/Protect Workbook, using a secret password. Then, nobody could change the data -- but they could still see it.

So then I hid the columns first, and then protected the sheet -- which did the trick. But that seems pretty cumbersome, because it involves two steps for me to open it up (unprotecting and then unhiding).

Is there a way to protect/hide in just one step so my sheet of passwords can't be seen by an intruder?

View 6 Replies View Related

Unprotect A Workbook With VBA And Re-protect It When Saved

May 13, 2008

I want the excel spreadsheet to "BE Protected" in standard form, and only be "Unprotected" when macros are enabled -- BUT DONT JUMP TO CONCLUSIONS, hear me out, it gets deeper than that

If the user does not enable macros, I want the book to be protected. If they do enable macros, it becomes unprotected.... (On load is good enough, no need to be real-time)..... But, they can save the book, so it would no longer be protected , which is where my question comes in ...

I could use the -unprotect "password"- on load when macros are enabled but this will only work if the spreadsheet was originally protected and is never saved again. This is a problem because this workbook will be given to others and will be saved time and time again.

So, I had a vision :-) .... function 'before save' , protect the sheet using -protect "password"- , allow the sheet to save, and then unprotect back using 'unprotect "password"' so you can continue using - BUT, the problem with this is now I have created an endless loop in theory, because after it unprotects it would want to re-save again because it changed

View 12 Replies View Related

Protect And Unprotect Workbook Using VBA Code

Oct 31, 2011

i'm looking for a vba code to solve the following problem a .xlsm workbook, the protect workbook passwork is known as "111111", the VBA project password is "222222", and how to write vba code to insert a new sheet, suppose the workbook has three worksheet, now using vba code to unprotect workbook, and auto insert a newsheet, then protect workbook again, whcih the password remains as "111111" using a commondbutton to do this, everytime you click, insert a new sheet.

View 9 Replies View Related

On Workbook Open Protect All Sheets?

Feb 19, 2012

Is there a simple one line VBA code to protect all sheets when a workbook is opened?

View 5 Replies View Related

Protect Sheet With Password In Workbook

Mar 15, 2012

I'm looking to password protect the sheets in my workbook (using vba) but I can't seem to join this up with allowing users to edit scenarios.

If I record the protection I get this:

Code:
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False

I normally use:

Code:
ActiveSheet.Unprotect Password:="password"

I just need to combine the two. Adding the password before 'DrawingObjects' or at the end doesn't seem to work.

View 5 Replies View Related

Password Protect Each Sheet Within Workbook?

May 23, 2012

I have 5 sheets in my work book.

Sheet Names:
1) PasswordPage - - I would like this to be the page where a user needs to type in their password. If it is correct, their own worksheet would display.
2) Sally - - Hidden and protected, unless Sally types in correct password. Sally's password would be Summer
3) Vanessa - - Hidden and protected, unless Vanessa types in correct password. Vanessa's password would be Pluto
4) George - - Hidden and protected, unless George types in correct password. George's password would be Carpet
5) Alexander - - Hidden and protected, unless Alexander types in correct password. Alexander's password would be Lampost

I would like to ensure that noone else see's anyone else's sheet unless they know the appropriate password, as each individual sheet contains sensitive information.

I also plan to "protect" each sheet also, so that the Sally, Vanessa, George and Alexander cannot make changes to the formulas, etc. - - this I already know how to do.

My question relates more to, How do I hide/ password protect each sheet as outlined above? I assume I must use visual basic, however I am not very familar with it.

View 6 Replies View Related

Protect Or Lock Workbook BEFORE Certain Date

Jul 7, 2012

How to protect or lock their spreadsheets after certain date.

My question is how to protect or lock workbooks before certain date?

Example:

I have individual woorkbooks for each week in a calendar year saved in one folder.

Is there any way that I can protect them from either being opened or if opened than not be able to save anything in them until one week before the calendar week they are designed for (or whatever date I wish to set)?

View 3 Replies View Related

Using VBA To Password Protect Entire Workbook

Nov 19, 2003

I have to use vbscript to add a password to an excel file i'm generating on the fly. I can't use the "Save As" option. Is there any other way I can do this? I need it to prompt the user before any data is displayed.

View 9 Replies View Related

Add Password-Protect Module In Another Workbook?

Jan 18, 2014

I am creating a File/Workbook using MACRO, however i need to ensure that one of the Modules in the created workbook remains protected and hidden...

Since there are lot of these files which are created, I would be interested in protecting them via a macro..

View 4 Replies View Related

VBA Code To Password Protect Workbook

Aug 14, 2008

I am trying to add a command button that will set a custom view, password protect all worksheets, and finally password protect the entire workbook structure. The code I am using will correctly set the view and add the password to the worksheets, but it will not apply the password to the workbook structure. What do I need to add?

Private Sub cmdReset_Click()

ActiveWorkbook.Unprotect Password:="test"
ActiveWorkbook.CustomViews("Sales").Show
ActiveWorkbook.Protect Password:="test"
ActiveSheet.Unprotect Password:="test"

Sheets("Accessories").Select
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False
ActiveSheet.Protect Password:="test"

View 7 Replies View Related

Protect Worksheet & Save Workbook

Oct 30, 2006

I want to find a code to lock all the cells with data once a button is pressed and with the same button click i want the workbook to be saved.

View 5 Replies View Related

Protect Workbook From Opening Without Password

Nov 19, 2006

protect all the sheets. I would want the password box to popup whenever, the excel file is opened unless the proper password is entered the sheets file should remain deactivated and when the password is entered it should be displayed as "*".

View 2 Replies View Related

Workbook Password Protect 2 Levels

Jan 22, 2007

On opening a workbook (XL2003) I want users to enter a password which will give them read Only permissions or access to the whole book. I do not want use the "save as" option it is not suitable for my needs & here is why. I have about 10 staff who need to fill in timesheets using XL SS on a public folder on the server. The staff need full access to file & management such as myself only need to view (read only) the timesheet without the ability to change data. Using the "save as" function the staff need to input 2 passwords.

The staff (in general) are not overly computer literate so I was hoping to be able to write code so that on Workbook_Open event only one password is entered and depending on the password gives the user full access or readonly access. This will also save management having to remember different passwords for read only access to different staff timesheet files & will give crude protection to the files.

Private Sub Workbook_Open()
Dim Message, Title, Default, Password As String
Message = "Enter your password" ' Set prompt.
Title = "Password" ' Set title.
Default = " " ' Set default.
' Display message, title, and default value.
Password = InputBox(Message, Title, Default)
If Password = "test" Then
Workbook.ReadOnly = True
Else
Workbook.ReadOnly = False
End If

End Sub

Error occur on "Workbook.ReadOnly" lines . I also want to put an errorchecking code for invalid passwords. Again, I know I can use the "save as" option but that is not what I need.

View 7 Replies View Related

Protect Workbook From Editing / Viewing

Feb 14, 2008

I have placed a workbook on a network drive. This workbook contains sensitive information and I would like to protect it to a "feasible" degree. I have written the following code

Private Sub Workbook_Open()
Dim userid As String, valid_userid As String
Dim i As Integer
valid_userid = "MISI01/"
userid = GetUserName()
userid = UCase(userid) & "/"
i = InStr(1, userid, valid_userid)
If i = 0 Then
MsgBox ("You are not authorised to use this workbook")
ActiveWorkbook.Close False
Exit Sub
End If
'create menu when workbook opens
Call Module1.CreateMenu("")
Call Modul1.check_filedate("")
' This will disable the user from moving, renaming etc the sheets
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub

As can be seen from the above code, I check if the current userid is one of those that are valid to open the workbook. If not the idea is to tell them and close the workbook immediately (this bit isn't tested yet). This code is not supposed to be hacker proof, but to prohibit the casual user from reviewing the the data.

View 3 Replies View Related

Real Security For Excel - Protect Workbook

Oct 5, 2013

I have a workbook which i really want to protect. I don't want any formulas to be seen and tampered with.

Simply hiding/locking cells and protecting the sheet is not secure enough. within minutes of googling crack password, i was able to find a macro that unlocks the sheet.

Is there something out there that can really secure your workbook. I found something called XLS Padlock [URL].... seems great.

View 2 Replies View Related

Permanently Hide Toolbar And Protect Workbook?

May 29, 2013

Is there a way to permanently hide the toolbars and protect the workbook that when others open the document, they will not be able to view or have access to this.

View 6 Replies View Related

How To Protect Cells/columns In Multiple Sheets In A Workbook

Sep 9, 2009

I'm trying to protect the contents of columns in multiple sheets in a workbook. I've tried to group the columns ( - months, i.e. sept, oct, nov 09 through to march 10) but when I go to Protection options the 'sheet' protection option is not available, all I can do is protect or unprotect the entire workbook.

I've also tried to protect the workbook, but individually set the specific columns in each sheet to be protected (repetitious but seemingly unavoidable), but this doesn't work well either as there's now a mix of a protected workbook and protected columns, both with individually set passwords to unprotect... which seems a bit silly.

There must be a way around this? - the columns are H, J, K and L, and the entire contents of the summary sheet '2009-10 Financial Year'... basically I'd like to be able to protect all of the contents of all of the cells here, ideally just with one password.

View 9 Replies View Related

Excel Workbook Protect - View And Hide Option

Apr 18, 2013

I have hide workbook in view and hide option, when i unhide the same it should ask password. Is it possible.

View 1 Replies View Related

Code To UNPROTECT Then PROTECT Workbook When Macro Runs

Jul 24, 2014

Okay, I have this code and it works very well - but it only works if my WORKBOOK is unprotected. I know how to Unprotect then Protect an ActiveSheet, but I can't figure out how to Unprotect then Protect my workbook when the macro runs..

Sub BLM_RENAME_SHEET()
Dim WS As Worksheet
Application.ScreenUpdating = False
For Each WS In ActiveWindow.SelectedSheets

[Code] ......

View 9 Replies View Related

Workbook Enable Macro Protect / Unprotect The Sheet

Sep 4, 2009

I need a macro that I can have in any workbook enabling me to protect / unprotect the workbook that I have currently opened with a set password (let say "Password")

I would link this macro to a button in excel 2002. I have try the following but it doesnt work

Would it be possible that the button (first) works (second) understand whether or not protect / unprotected and do the opposite?

Sub Protect
Activeworkbook.protect password:="password", structure:=FALSE, Windows:=false
End Sub

View 9 Replies View Related

Protect Micro Enabled Workbook Being Copied On External Memory

May 14, 2012

I have this micro enabled workbook and I want to protect it from being copied on other sources.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved