Sheet Protection Causes Macro Error

Jun 29, 2007

I've been using the attached spreadsheet to record daily sales for a while now, however, we've recently intorduced a new product and so I've had to add a new column to record daily sales of it.

On the spreadsheet is a 'New Week' button. Pressing this deletes all entries and moves the week numbers on by 1, so giving me a blank template each week. However, after the addition of the new column I'm now getting a bug error message. I've adjusted the code to take account of the new column but I'm still getting a bug error. When I press 'debug' it's highlighting something I have changed so I'm a little confused why I'm getting the bug error. Would someone have a look for me. I only seem to get the bug when there is protection on the sheet, I need protection. The password is PHUKET38

View 9 Replies


Run-time Error '50289' :: Project Protection / Module Protection / Module Visibility

Aug 18, 2004

I recieve an error :

Run-time error '50289':
Can't perform operation since the project is protected.

When i try and run my code.

The code does add parts to modules and workbook events, but I need the code to be protected.

View 9 Replies View Related

Macro: Protection From Same Password To All Sheet

Aug 1, 2007

i have a spreadsheet with about forty different sheets and all of these sheets are protected with the same password, and wheni come round to doing an amendment to the spreadsheet i have to unprotect and then re protect each sheet in turn, very time consuming

each sheet is naturally named different

View 9 Replies View Related

Event Macro Causes Sheet Protection Prompts

Jan 26, 2007

One of the things it does throughout the course of the run is unprotect the worksheet, do what it needs to and then reprotects the sheet (using a password). On the second run, the sheet protection input box is shown and I am required to input the password before the code will execute.

The code that I have written uses an Add-in that pulls data from a database. As part of that retrieval, the other add-in protects the sheet without a password. Would that be causing my error?

View 6 Replies View Related

Modify Macro To Check And Turn Off Sheet Protection.

Dec 14, 2009

I am using the macro below to import every spreadsheet into a folder. I would like to modify it to check the sheets it is importing for sheet protection. If the sheet protection is turned on, I would like it to turn it off. The password for the sheet protection will be "PIR".

View 3 Replies View Related

How To Setup Sheet Protection

Nov 27, 2012

When I protect the entire sheet, I can click in a cell and see what's in it, when I protect just a portion of the sheet, I can only click in the unprotected cells. Is this an Excel thing, or am I doing something wrong when protecting? I would like to see what the formula is in the cell when protected, but I can't click on the cell, what's the deal?

View 8 Replies View Related

2002 Sheet Protection

Feb 20, 2003

Is it true that the sheet protection in excel is practicaly none ?

Not even excel 2002 (XP) prevents simple cracking software from removing sheet protection.

Are there any master keys that cause that ?

Is there a way to protect a sheet with strong encryption ?

View 8 Replies View Related

Password Protection A Sheet

Jun 29, 2006

Is there a way to password protect a sheet so that you have to enter a password just to access it. I dont want most users to be even able to view one sheet unless they have the password.

View 2 Replies View Related

Password Protection Through A Sheet

May 14, 2007

I got this form RoyUK and was wondering if anyone know why it comes up with a debug here

Option Explicit
Dim sPw As String
Dim i As Long
Dim r As Long
Dim iChk As Integer

For Each rCl In .Range(Cells(r, 3), Cells(r, Columns.Count).End(xlToLeft))

View 9 Replies View Related

Why Is This An Error In Sheet Code But Not As Macro

Dec 20, 2007

Why does the "else" section of this code cause an error when part of a sheet code but runs fine in a macro?

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B3")) Is Nothing Then
Exit Sub
Application.ScreenUpdating = False
Target2 = Range("Analysis!A1")
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.ScreenUpdating = True
End If
End Sub

View 9 Replies View Related

Sheet Protection Problem With Groups

Mar 19, 2007

I have an excel workbook I'm working on, and it needs to be protected. I have some groups that can be expanded or hidden, but once the sheet is protected you can no longer use the little button to hide or expand the group.

View 9 Replies View Related

Transferring Sheet Protection From One Worksheet To Another Via VBA

Nov 29, 2011

Any way to transfer the sheet protection from one worksheet to another worksheet via VBA.

Currently, the user selects a name from a drop down list, it unhides a workbook of the same name, copies from that workbook, and places the copied information in an area of the sheet with the drop down list. I would like the protection settings (in this case, selectivly unlocked cells to allow users to easily tab through and not make changes to data that should not be changed) to be copied with this information. Is this possible?

View 2 Replies View Related

Inserting Rows And Sheet Protection?

Jan 8, 2013

I have a piece of code with a couple of errors. The code selects a certain row and then copies and inserts this row on the last line with data, the number of rows is decided by the user via a form. The line of code with the error is highlighted, think it is a syntax/grammar error.

Sub InsertRows()
' Inserting Rows
Application.ScreenUpdating = False


View 9 Replies View Related

Show Status Of Sheet Protection

Sep 14, 2009

I have a workbook with about 70 sheets, some are specific for data entry, others for data review.

I share the workbook with my data entry team, and lock the review sheets so that no one can modify the data on them or change the formating. End users review the final protected sheets for the information that is appropriate to them.

I need to track the status of the protection of each sheet, such that I can edit the sheets as needed, then protect / lock them once I am done.

Is there a way to indicate, in a cell within the indvidual sheets, the status of protection for that sheet?

For example, if the sheet is protected, the Cell would read "LOCKED" and if the sheet is not protected, the cell would read "EDIT".

View 9 Replies View Related

Cell & Sheet Protection Basics

Mar 27, 2008

I have 2 spreadsheets: in a Sheet1 I keep some values and in a Sheet2 5 names of users with special rights (range A1:A5). I want to have sure that anybody will change/delete that names without password. Only the user "Administrator" can do that(I check the name of the user using "Application.UserName"). Additional question: is it possible to still protect those cells if somebody turn off macros during opening file?

View 4 Replies View Related

Error Running Macro When Sheet Is Protected

Sep 9, 2008

I am getting an error when I protect a worksheet and save it. Upon re-opening the worksheet, I try to use the cells that are being formatted by a macro, but I get the following error...

Run-time error '1004':

Unable to set the NumberFormat property of the Range Class.

If I open the worksheet and it is already protected from when I last closed it, then I get the error. If I unprotect the sheet, then close it and reopen it, then I don't get the error. Does anyone know what I might be missing or doing wrong.

View 9 Replies View Related

Sheet Protection Column Width Lock

Jan 16, 2014

I am trying to Protect a Sheet to lock the width of just one column. Does the lock apply to all the columns in the worksheet or can it apply to a single column only. I can't seem to get this to lock just one column-if it is possible.

View 1 Replies View Related

Remove Sheet Protection From Every Workbook In Folder

Dec 28, 2009

I have tried to cobble together a macro to remove the sheet protection from every sheet in every workbook in a folder. Not surprisingly, it is not working. Unfortunately, I have reached the limits of my VBA abilities.

View 9 Replies View Related

Copy Cells Removes Sheet Protection

Feb 1, 2007

I have hidden columns on a sheet.
I protect the sheet with a password before I send out the file to a 3rd party. However, it seems that all a user has to do is select the sheet cells, copy and paste onto another sheet or file. The protection is nonexistant and the user is able to unhide the columns.

Am I missing something?
Is there a way to "really" protect a sheet so that a user is unable to unhide confidiential columns? Preferably a method without VBA code.

View 9 Replies View Related

Auto-Refresh AutoFilter With Sheet Protection On

Nov 23, 2008

I found one of your old VBA entries that allowed me to automatically refresh an autofilter function, and it works great.... with protection off.

As soon as I protect the sheet so users can't enter data into the pages showing the autofiltered data, the autofilter kicks off.

i have set the protection to allow autofiltering, so it's something that is preventing the macro (for automatically updating/refreshing the autofilter).

I'd love to either fix the macro to "autorefresh autofilter" with protection on, or just enter another code that will disable all functionality on the worksheet. (workbook is set up with multiple sheets, first sheet is for all data entry, subsequent sheets are filtered data-trying to make them viewable only).

View 9 Replies View Related

Setting Protection Change To Rest Of Sheet After Last Row

Aug 8, 2006

I have a form that will be populated with different numbers of records. I need the records to be locked, but the remaining rows (if the user needs to add new records) to be unlocked. Can I use some sort of range.end function for this?

View 9 Replies View Related

User Allow To Format The Cell And Text In Protection Sheet ?

Jun 1, 2006

how to allow formating a text and cell in protect sheet ?

View 4 Replies View Related

Sheet Protection Conflicts With Code To Autosize Row Height

Apr 23, 2007

When turning on sheet protection, I get an error with the following code that I'm using to make sure rows adjust their height when lines wrap.


What can be done to eliminate this conflict? All of the cells I want available for editing are unlocked.

View 3 Replies View Related

VB/Macro Protection

Oct 8, 2008

I know how to protect VB code (e.g. Protection tab of VBAProjectProperties), however I would like to know how to embed code to stop the user from accessing the Macro (via Run Macro).

I understand you can do this by adding "Private" to the subroutine, however, is there some code I could add into a macro/connecting to a button, that would enable the user to protect the sheet (without needing to manually type private within the Module subroutine)?

View 9 Replies View Related

Runtime Error Hidden Property - Macro Not Working In Protect Sheet

May 3, 2012

This first macro works fine:

Sub UnhideHBPorCholesterolQ1toQ3()
ActiveSheet.Unprotect "password"


why the second macro does not seem to work. I get a Run-time error that says "Unable to set the Hidden property of the Range Class".

View 1 Replies View Related

Protection Stops Macro From Running

Jun 10, 2008

I want to make the worksheet protected, however, when I protect the worksheet the macro will not run.

View 14 Replies View Related

Cell Protection & Clear Macro

Oct 14, 2008

when i password protect my sheet it doesnt let my clear cells macro work on the cells i need it to clear why is this and what way is there around this completes my complex sheet.

View 2 Replies View Related

Password Protection For A Macro Button

Dec 8, 2008

I have a button that executes a macro which basically activates a worksheet. I wish to put a password which would allow only certain users to access this worksheet through this button.

View 2 Replies View Related

Get Password For Protection In Macro From User

Feb 26, 2007

My macros are set up with hard-coded passwords to protect and unprotect the sheets where they run.

But I need a way for the macros to refer to a user-provided password without having the user edit the macos themselves. The simplist approach (I suppose) would be to have a worksheet for this with a cell for the user to enter the password he/she wants. The macro protect/unprotect code would then look at the cell to get the password.

View 9 Replies View Related

Worksheet Protection From Editing And At The Same Time Allow All Data Source Links Within The Sheet To Be Refreshed

Mar 16, 2007

how to protect a worksheet from editing and at the same time allow all data source links within the sheet to be refreshed? I need my users to be able to refresh all data links as required but not be able to change the worksheet in any other way.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved