# Simultaneous Protection

Dec 18, 2009

I have set up a workbook containing 15 sheets. 12 of them are named Jan to Dec. I KNOW how to protect each one, but is it possible to protect all twelve in one go?

## Simultaneous Collaboration

Jan 18, 2007

It is my understanding that two or more people can simultaneously work in and save data in a given workbook.

Is this true?

If so, how does one set up the collaborative mode? Currently we are getting "the first person in has control of the file, all others are 'read only' until the file is released".

## Sum Simultaneous Operating Hours

Jan 16, 2013

I'm putting together a workbook which tracks operating hours for 17 pieces of equipment (units) at 7 job sites.

I need to track and record the number of hours where at least two of units 1-6 operate simultaneously each month.

So far I have only succeeded in creating another table which pulls all records for units 1-6 from the Log. The table can then be sorted by date (for some reason, this sorting only kind of works) so simultaneous operating hours can more easily identified and summed manually.

I'll attach a workbook with mock data which shows what I have so far. The complete workbook also does some other calculations which I have removed for clarity. That is why there is some "extra" info in the workbook.

The workbook is set-up where:
LOG: This is where the user records when each unit was operated.
LOG2: This is where I've attempted to isolate records for units 1-6 and sum simultaneous operating hours.
Factors+Limits: This is where the fields for the lists are stored as well as other factors used throughout the workbook.
Monthly: I'd like to be able to records simultaneous operating hours here.

## Solve Set Of Simultaneous Equations

Oct 9, 2007

I am trying to solve a set of simultaneous equations by using SolverOk function in VBA.

I dont want to use the 'SetCell' option so, I wrote the following

SolverOk MaxMinVal:=1, ByChange:= Range("V34:V36")
SolverSolve

but I get an internal memory error. However, if I use the solver dialog box directly from excel and not through a macro and keep the 'Set Target Cell' as empty, I get the right solution.

## Simultaneous XMLHTTP Posts W/Event Handler

Jul 12, 2006

I have a standard module in which I gather information from a workbook, create an XML document, Post it, and collect the value I need from the response XML. Thing is I have to run through it maybe hundreds or thousands of times depending on the number of records I have. It takes ten years to finish the loop. I have read that it might be possible to post them concurrently using a class module and an event handler, but I have not worked with Class modules before. Compiling all the XML documents into memory is easy, posting them and getting my return values in a timely manner is the problem at hand.

## Count Simultaneous Rows With Same Cell Value And With Time / Date Condition

May 9, 2014

I have rows of data in excel that update automatically and i want to check in column B how many times there are simultaneous occurrences of a cell value and then if those occurences have been there for a time specified time duration using column C which has a time and date stamp. The time and date stamp is when the price is saved down.

A Simplified Example:
Item
Action
Date & Time

Red
09/05/2014 09:00

[Code] .....

What I would like the formula to is to count the occurrences of cell B that have been avilable for longer than say 30 minutes.

Formula that worked out the occurrences of cell B with this formula

So if i wanted to count the simultaneous occurrences of "Buy" then the formula would result 1 and the same for sell if i changed the formula would be 2.

Now i want to try and get a way of using the time those occurrences were available for by using Column C

The simultaneous "Buy" was available from 09/05/2014 09:00 to 09/05/2014 11:01 which is longer than 30 minutes so i want to count that as a occurrence.

Then both the "Sell" were only available for 14 minutes the first time and then only for 20 minutes the second time so none of those would count.

## 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.

## VBA Protection

Mar 22, 2009

I have a macro that copies the contents of a cell, and pastes it into the the first blank cell of a range. Its important that the entire sheet is protected, but the macro won't allow the paste function because of the protection.

Is there a VBA code to unprotect the sheet, run the copy/paste macro, then protect the sheet again. THe problem is I would prefer the protection to use a password, as I don't want the user to simply unprotect the sheet from the menu bar.

## Set Protection Using VBA

Aug 10, 2006

I tried the following code and it doesn't work:

Sub Macro2()
Cells.Select
Selection.Locked = True
Selection.FormulaHidden = False
Range(Range("A" & Rows.Count).End(xlUp).Row & "A300").Select
Selection.Locked = False
Selection.FormulaHidden = False
Range("AE11:AG300").Select
Selection.Locked = False
Selection.FormulaHidden = False
End Sub

I want to be able to unlock all cells after the last cell that has data in column A down to row 300. Also need to unlock cells AE11:AG300. What's wrong with my code?

## Column Protection

Nov 1, 2008

I have a worksheet where there are a few columns. The columns involved in my problem is Column A and B. So the users open the worksheet and they change the values of column A. Column B has a vlookup formula and if the value of column A is changed than column B automatically changes its value as well (vlookup).

My problem is that the users of this file are not experienced computer peoples so, sometimes (by accident) they change the value of column B (deleting the formula). I tried to set the protection for column B.... but then it will not allow any change (vlookup will not work) to the cells in column B. So my question is that how can I allow the users to see the values in column B but not to edit it..and also let excel to let the formula to change the values of column B (if column A value is changed)?

## Cell Protection

Nov 5, 2008

is there a way that i can stop people being able to edit certain cell in a sheet but still allow them to type in other cells as when i have tried diffrent ways it locks the whole sheet

## Worksheet Protection When Using VBA

May 2, 2007

I have a worksheet that I want to protect, but when I use the protect worksheet command on the tools menu, it renders all of my VBA useless.

## 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)?

## VBA WorkBook_BeforeSave And Protection

Dec 11, 2008

I'm trying to set a check during the WorkBook_BeforeSave event.

## VB Project Protection

Feb 12, 2009

I'm trying to protect my project so that others can't unhide a sheet I have tagged as veryhidden within VB.

I followed these steps:
1. Select project in the projects window
2. choose Tools
3. Project Properties
4. Protection tab
5. checked lock porject for viewing
7. clicked ok and saved

On another file this has worked perfectly as I wanted it to.

However on another very large file with multiple VB projects it is not "taking" on the project I need it to.

I can open the file, the VB project and change the setting on any sheet I need to without entering a password.

## Macros And Protection ..

May 22, 2006

I have a scoresheet with 60 contestants. Each contestant takes up 7 rows,
the first six of which are hidden to start with and I have put macros in the
adjoining column so that when they are clicked, the full 7 rows open up and
the table of scores can be entered, When entry is complete for that
contestant, a further macro when clicked will close up the 6 rows, leaving
just the main line (line 14) with the No, Name, “OPEN” macro and other Totals

The sheet works fine, but as many people will use this programme, I need to
protect the sheets against mistaken entries etc., and as soon as I protect
it, the macros wont work and throw up a “unable to set the property of a
hidden range class, run time error 1004. I don’t want to leave the sheet
unprotected, can anyone advise me where I am going wrong.

I am also trying to find a way to validate “time taken” entries so that they
can only be input as minutes and seconds in the format of 09.56, within a
range of 00.01 – 10.00. Not having any success with this as it keeps
converting the data into something like a date.

## Worksheet Protection

Jul 23, 2007

On my worksheet i am using advanced filters to view the data in the sheet.
But when I protect the sheet they do not work, I have unlocked those particular cells (Row 1). But it still does not allow the use of the advanced filter when the sheet protection is on.

Aug 28, 2007

I use the following piece of code to show/hide certain worksheets in a workbook. To access the hidden sheets, a command button runs the code. It works very well, except that the password is openly displayed in the message box (as opposed to returning asterisks for the typed characters).

Sub togglesheets()
Dim Ws As Worksheet
Application.ScreenUpdating = False
For Each Ws In ActiveWorkbook.Worksheets
If Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVisible Then
Ws.Visible = xlSheetVeryHidden

ElseIf Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVeryHidden Then
Ws.Visible = xlSheetVisible
End If..............

## Protection Of A Different Sort

Jan 22, 2008

This is something someone asked me and told me it's possible without VBA. I don't know if it is. I'm sure if it is possible, someone here would definitely know!

I have workbook, which I can not protect. It's sort of a template, so is used again and again with different data. It's accessible to many users. However, I don't want any changes in that workbook once it is closed.

For example, a user opens the workbook, he makes changes in the data, takes the outputs and uses it somewhere else. Now, when he closes it, it should revert back to the same as it was when it was opened. Even if the user saves it and closes, it should remain the same.

## Auditing Protection

May 21, 2008

Is there a function of formula in Excel that will show me which cells are protected. I have a worksheet that needs certain cells to be protected. I don't know how i can get on good look to see if the are all protected.

Is there a conditional formatting formula possible.

## Proper Protection

May 27, 2008

Is there any way I can protect my sheets properly..? I know you can use Tools > Protection.. but I've found (and used, for good, not evil!) macros on the web that will crack these in seconds. Is there any way I can disable the 'Tools' menu so that other users can't load these password crackers?

## Macros And Protection

Jul 3, 2008

I have a excel Workbook, 6 sheets and many calculations with formulas and macros.

Is there a way to protect this workbook to be able to insert data only in the correct cells, I tried but the macros does not work, they are essentially copy and paste.

there will be 3 sheets with reports to be printed too.

## Protection Not Quite Protecting

Jul 24, 2008

I have a workbook and i have spent time protecting all the formula cells and allowing user to only be able to select unlocked cells (so they can quickly tab to where they need to input info).

I have lots of codes running and always use Activesheet=unprotect If i am modifying protected cells and then at the end of the code i put back the activesheet=protect.

HOWEVER

When i transfer this book to another machine or to someone else to run it on their machine - ALL of my protection GOES OUT THE WINDOW

Also - is there a way to hide or protect all my code so that users cannot modify it?

If so - how do i get it back to modify state when i want to edit it?

## Sort Protection

Aug 25, 2008

I have an Excel sheet that I want to distribute
And I do not want the recipients to be able to
Change or sort the data.

I used Tools > Protection >Protect Sheet
(Contents,Objects, Scenarios are checked) >No Passord.
The original sheet cannot be changed or sorted.

But if I Copy and Paste it to a new Excel file
I lose that ability.

How can I fully protect the sheet
So it cannot be changed or sorted if
It is copied and pasted to a new sheet?

## Pasword Protection

Oct 30, 2008

How do you protect a workbook with a pasword in 2007 ???

## No Autofilter With Protection On

Dec 18, 2008

It is my understanding that the autofilter should still work on a protected sheet, but despite all of my efforts I have not been able to make this work. I have tried adjusting the settings on the protection to allow filters, formatting, and everything else I could think of all to no avail.

What am I missing here? This is the same on several different spreadsheets that I have put together.

## Protection Of Sheets

Aug 24, 2009

I have at average 10 sheets in one workbook. I have to protect 9 workbooks.

Can I protect one workbook in one go rather than protecting each sheet in every workbook?

## Check For Protection

Apr 25, 2006

I'm running a macro on Workbook Opening that checks to see if the sheet is protected, and if it is, unprotect it. I have used the code (simplified):

If Activesheet.Protect = True Then
Activesheet.Unprotect
End If

Unfortunately this seems to protect the sheet if it isn't already protected. Have I used the wrong first line perhaps?

## File Protection With Vba

Apr 2, 2007

I need to protect excel file. I have search vba codes and tried to combine :
1. Must enable macro on open
2. Input user id and password
3. Disable cut, copy, paste and print
but not work.
user : test
Details as per attachment

Jun 5, 2014

I am trying to protect my file with a password which does not contain capital letters and contains less than 12 characters.

How can I do that?