+ Reply to Thread
Results 1 to 9 of 9

Errors on Protected Sheet

  1. 02-14-2014, 01:16 PM #1
    Erwin W
    Erwin W is offline
    Registered User
    Join Date
    02-11-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Errors on Protected Sheet

    I have just finished my excel application and I protect all of the sheets in my workbook.
    The problem is every time I try to write on unprotected cells in a protected sheet and press enter/tab/ or simply move to other unprotected cells, I get the following error message:

    The cells or chart that you are trying to change is protected and therefore read-only.
    To modify a protected cell or chart, first remove protection using the Unprotect Sheet Command (Review tab, Changes Group).
    You may be prompted for a password

    I keep on getting around 2-3 such warning messages, and after that everything work normally i.e. the value of the cells change to the value that I have typed.
    However, I found that this error is really annoying.
    Is this a bug in excel application? or have I made a mistake?
    Is there a way I can disable this error message?
    Reply With QuoteRegister To Reply
  2. 02-14-2014, 01:39 PM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Errors on Protected Sheet

    Hello Erwin W,

    Unprotect your sheet/s, and then select the Cells which user/s may enter data into, and with Format Cells, select>Protect> and uncheck the Protect Box.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 02-14-2014, 01:47 PM #3
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Errors on Protected Sheet

    Hello Erwin W,

    I forgot to ask you if you have any VBA Code in the Workbook ?

    If so, then please upload a sample of same, for us to have a look at, for you.
    Reply With QuoteRegister To Reply
  4. 02-14-2014, 03:46 PM #4
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Errors on Protected Sheet

    Are the "problem" cells Unlocked? Unprotect the worksheet, right click on a problem cell, choose Format Cells, Protection and uncheck the Locked selection box. When re-protecting the worksheet make sure that you are allowing the user to Select Unlocked Cells and nothing more.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  5. 02-15-2014, 05:12 AM #5
    Erwin W
    Erwin W is offline
    Registered User
    Join Date
    02-11-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Errors on Protected Sheet

    I have already unlocked some of the cells before I protect the sheet. However, I still get that error messages.
    I have uploaded a sample from my project here, I have deleted most of its contents so it may seems like a mess.
    Just try to fill in the cells in yellow and press enter, and you will get the error message that I have mentioned.
    The weird thing is if you unprotect the sheet and delte some of its contents, the error message will no longer be shown.
    I wonder what cause this error message to appear.
    Thanks for your help!!
    Attached Files Attached Files
    Last edited by Erwin W; 02-15-2014 at 05:49 AM.
    Reply With QuoteRegister To Reply
  6. 02-15-2014, 09:20 AM #6
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Errors on Protected Sheet

    Until I activated the macro, the cells in yellow could be filled in. When macros were enabled, errors occurred when filling in the yellow area. An error message stated that the chart being updated was protected and read only.
    Reply With QuoteRegister To Reply
  7. 02-15-2014, 09:54 AM #7
    Erwin W
    Erwin W is offline
    Registered User
    Join Date
    02-11-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Errors on Protected Sheet

    Yeah, I keep getting that error message.
    But there is no chart in the workbook at all, right?
    Reply With QuoteRegister To Reply
  8. 02-15-2014, 10:10 AM #8
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Errors on Protected Sheet

    I don't see a chart but, as soon as macros are enabled the errors start. Something is improperly protected. I'm no VBA expert so I can't trouble-shoot that.
    Reply With QuoteRegister To Reply
  9. 02-18-2014, 08:26 PM #9
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Errors on Protected Sheet

    Hello Erwin W,

    Your problem is not VBA related. The ComboBox1 on Tab B is linked to Cell S1, which, with Protection is Locked. UnProtect Tab B, right click on Cell S1>Format Cells>Protection, and uncheck the Locked Box, then Protect the Sheet again. Everything should then work just fine.

    Regards.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vba changing sheet tab color when it was protected/not protected
    By mcmunoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 05:39 AM
  2. [SOLVED] Copy protected sheet to a NEW workbook that is not protected
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2012, 11:50 AM
  3. 2010 Web Query on password protected page errors
    By forrie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2012, 09:15 PM
  4. Delete rows in a protected sheet with protected cells
    By Maranwe in forum Excel General
    Replies: 7
    Last Post: 10-31-2011, 08:12 AM
  5. macro to batch fix errors on password protected workbooks
    By spence in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-07-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1