VBA Code to Unprotect a Worksheet then Protect

**aalbertson** · 09-23-2011, 01:39 PM

Hi,
I have created a form with Macro in it and have locked cells so you can tab thru each cell easily. I protected the workbook but the problem is that when I run the macros it gives me an error because I have to the workbook protected.

I am looking for a VBA code that when I run one of my macros it will UNPROTECT the sheet, run the macro and then go back and Protect it.

Can someone help?

Thank you!

**royUK** · 09-23-2011, 01:55 PM

Please Login or Register  to view this content.

Or look at Protection wuith UserInterface

**aalbertson** · 09-23-2011, 01:59 PM

I forgot to mention that the macro is running off of Sheet 2 and putting in the information in Sheet 1.
In the code I need it to Unprotect Sheet 1 run the code then Proctect sheet 1 again.

Thank you!

**royUK** · 09-23-2011, 02:01 PM

Simple enough, replace ActiveSheet with Sheet1

**BRAY1980** · 11-12-2011, 02:09 AM

Hello. I am working on a time clock program for my company. I need some assistance in figuring out how to write a code so that a cell is locked, then unlocked when a button is pressed to record the time, then locked again. I have this process already set up; however, I cannot figure out a way to only have this process be performed once. Right now, if the associate presses the button, the time will continue to be replaced. Below is the code I have for one of the buttons. Any help will be greatly appreciated!

Sub AA()
Range("D5").Select
ActiveSheet.Unprotect ("8827")
ActiveCell.Value = Format(Now, "'HH:MM AM/PM")
ActiveSheet.Protect ("8827")
ActiveWorkbook.SaveAs Filename:=Range("B6").Value
End Sub

**royUK** · 11-12-2011, 04:03 AM

Welcome to the Forum, unfortunately your first post has broken 2 rules. You need to read the Forum Rules

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.