Use Dropbox When Sheet Is Protected

Jan 26, 2009

I have a dropbox located on a sheet which other information needs to remain protected.

How do we give access to users to the dropbox while the remainder of the sheet is protected?

View 9 Replies


ADVERTISEMENT

Excel 2010 :: Macro Runs On Protected Sheet But Changes Protect Sheet Options?

Feb 24, 2011

I am using Excel 2010 and I have a password protected workbook with password protected sheets that uses several macros. Most of them, in order to run, have to un-protect the sheet and then re-protect it again. This has been accomplished easily enough by adding ActiveSheet.Unprotect Password:= "mypassword" and ActiveSheet.Protect Password:= "mypassword" to the appropriate places in the script. All of my macros, which do various things like sorting and moving data, deleting blank rows, displaying dialog boxes containing warning messages etc. run fine.

My problem is this: when I password protect the sheets manually, I have checked the following options in the "Protect Sheet" dialog box. Under "Allow users of this worksheet to" I have checked 1)Select unlocked cells and 2)Format cells. After entering my password and closing the dialog box my sheet is protected, but I can edit cells in the manner my allowances permit. However, once I run any of the macros that un-protect and re-protect the sheet, I remain able to select and edit unlocked cells (practically, for my purposes, this means that I can input data which will appear in the default font size and color of the sheet) but I cannot format cells (which, practically, for my purposes would allow me to occasionally change the font color and size of the data). Naturally, after running a macro, the other cell-formatting options are unavailable to me as well. Is there any way to get my manual selections to remain in place after running a macro that functions as mine do? Or is there any way to make my manual selections the default settings for a protected sheet?

View 4 Replies View Related

Copy And Paste From One Sheet To Another On Protected Sheet?

Apr 29, 2014

I have spent ages creating a work diary and have protected the sheets using VBA however on finishing the sheet one important thing that needs to happen is the ability to copy and paste information from the boxes to another worksheet. i.e MONDAY - SUNDAY

View 1 Replies View Related

Password Protected Sheet :: How To Unprotect A Sheet?

Jan 18, 2008

Does anyone know if there is a way to unprotect a sheet. The person who created this spreadsheet no longer works for our company and although we can see the spreadsheet, the formulas are hidden so we can't figure out where the data is being pulled in from. Any ideas?

View 9 Replies View Related

Making Dropbox From Datatable?

May 6, 2014

I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc.

View 5 Replies View Related

Conditional DropBox (5 Variables)

Jun 11, 2014

I have a table with a lot of variables and i need to extract some of the values of that are conditionated by 5 variables and put them in a drop box. How can I do that???

The first picture is a part of my "help table" and the second is the table that i want to fill.

In yellow are the problems...

first.jpg
second.jpg

View 12 Replies View Related

Sum Based On Dropbox Date

Jan 31, 2014

I have a drop down box in "U2" which is pulling a date. 31/01/2014, 28/02/2014 and so on..

In "S6:AD6" I have the same dates. I want to be able to, in "AE16" have a sum from anything before or equal to the figure in "U2".

View 5 Replies View Related

Can Worksheet_BeforeDoubleClick Work Over A DropBox?

May 13, 2009

I have a macro procedure that runs when doubleClick. This procedure is writen on the Sheet code under the "Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)".

I realize that when there is a dropBox, the procedure does not start. It drops the dropBox menu instead of running the Macro.

Is there any way to make the procedure run even when doubleclicking on DropBoxes?

View 7 Replies View Related

Incorporating DropBox Files Within Excel

Oct 31, 2013

I have a number of files organised in a number of folders on Dropbox. I create a macro to enable me to be able to navigate to a particular folder and then get a list of all the files in that folder to be placed within certain cells on the spreadsheet I'm working with in Excel.

View 2 Replies View Related

Combine Dropbox Selections Into New Columns?

Mar 13, 2014

FFLX9g.jpg

What I'm after is an easier way to get data combined without having to type it all out. If you look above I would like to have A-C actually as dropbox's or listbox's, something I can click, then drop down to the proper name and select it. Then on E I'd like a timestamp for when this action was done with the date and time as shown along with the reason. Then in F I'd like the Name fields combined so I just need to right-click on F and copy/paste into the other program I use.

Maybe one column can just be the names of everyone with a selection box and I click this stuff then when I am done it resets?

View 1 Replies View Related

Using Macro VBA To Select From Dropbox On Webpage

Nov 4, 2013

The thing is I can open ie explorer and navigate to the page I need. What I'd like to do is be able to select from a drop box on the web page when it's already open is this at all possible.

View 1 Replies View Related

Cant Use [alt] + Pg Up Or Pg Dn On Protected Sheet

Jun 11, 2008

is there a code to still allow me to move between sheet tabs by using [alt] pg up or [alt] pg dn on a protected sheet?

View 9 Replies View Related

If Sheet Protected Then...

Apr 26, 2007

What code would I use to test if the sheet is protected or not? In other words:

If Activesheet.Protection = True Then
MsgBox "You have no authority!!!"
Else
' Some code here
End If

View 5 Replies View Related

Searching A Protected Sheet

Feb 11, 2010

I have a workbook whose worksheets use protection (don't want my calculations stomped on).

When the Protection is on, the search function does not work. You call it up, write what you are looking for, it accepts it, and then when you tell it to search it ignores you.

When you turn the protection off, the search function works just fine.

HOWEVER....Other workbooks I have with protection on its sheets do not share this problem, just this one workbook. And the problem is on all sheets in this workbook. The problem is not on any of the sheets in the other workbooks. I can't see anything different between them, but then I may not know what to look at.

View 2 Replies View Related

Allow Insertion Of Row In Protected Sheet

Sep 4, 2013

I wanted to know:

Q1. How can we insert new rows in a protected sheet?

For example: In the attached sample protected excel sheet "insert rows.xlsx" , if for Employee ID and Name fields, the user has more no. of records than provided, how can he insert new rows considering the fact that Company ID and Name field are locked.

Or any way to address this issue via some other method like adding a scrollbar,etc.

View 5 Replies View Related

Protected Sheet & Allow Use Of Autofilter

Dec 20, 2007

I've locked certain columns on my worksheet so that users cannot overtype target dates etc. I've password protected the worksheet.

The password protection means that for some reason the users can't use the autofilters that are on the header row.

Can someone help me solve this problem; I still need the locked cells and password protection on the sheet but the success of the sheet depends on users being able to filter for specific rows using the autofilter....

View 9 Replies View Related

Protected Sheet Will Not Allow Macro To Run

Mar 27, 2009

I have protected several sheets in my workbook to protect the forumlas and data for being tempered with by the users.

When I try to run my macro, I get an error message stating:

Runtime '1004'
You can not use this command on a protected sheet

And the debug is pointing to this part of my code

View 14 Replies View Related

Autofiltering A Protected Sheet

Dec 11, 2006

When I protect my sheet and have the option to allow the users to autofilter the sheet, how come it doesn't work? I want to allow people to autofilter the data in the worksheet but not modify the contents of the cell.

View 9 Replies View Related

AllowFiltering In Protected Sheet

Nov 10, 2009

I have a question relating to the use of autofilter in a protected sheet.

My code is working fine in setting the autofilter and locking down the sheet but a user then loses the ability to use the (Data - Filter - Show All) menu button.

Is there a way to have the worksheet protected, allow the use of the auto filters, and allow the use of the show all button?

Code below incase it is of relevence ...

View 9 Replies View Related

Copy Down Last Row On Protected Sheet

Jul 31, 2008

I am looking for VBA code that will unprotect the Workbook, prompt the user for the number of rows to be added, find the last row in the Worksheet, insert the requested number and reprotect the Worksheet. I would like the location where the rows are inserted to NOT be dependent on the "active" cell.

View 6 Replies View Related

Range Name + String As Source For Data Validation DropBox

Jul 16, 2009

I have several cells with data validation's drop Box. Every data validation uses a range name as source (myColorList). Here goes the hard part: I need a new value inside the dropBox list, but The problem is that I can NOT modify the "myColorList" range.

-- Is there any way to build up the dropbox source using the range name and the new value? Something like

View 2 Replies View Related

How To Merge And Unmerge In Protected Sheet

Sep 15, 2014

I have a protected sheet to avoid delete of functions. In a specific area, however, i have merged cells of five columns in rows. Because in these lines i have write some text and overcomes the rows, after, what i do is: i unmerge the rows and choose 3 rows from 5 columns together and merge. Thus, the text is in one framework. In fact, every time, i want to merge different regions, but always i want to merged any areas who have marked with the mouse. Then, i delete the text and i need to redo the context of three lines, three separate lines. I hope you understand what i need.MergeAndUnMerge.xlsm

View 1 Replies View Related

Automatically Paste Row On Protected Sheet?

Jul 30, 2008

I want to allow user copy(Ctrl + C) and paste(Ctrl + V) a row. because some columns are locked and the sheet is protected. so, when user doing so, a warning dialog is show and can't do the paste.

so, I want to make it available in code. what I want to do is add some codes in this function:

VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = True Then 'there are someing in clipboard
Sheet1.Unprotect 'unprotect sheet, so can paste
End If

and in Worksheet_Change function, I protect the sheet again.

But I find that when I do Sheet1.Unprotect , the clipboard is empty! I just want to allow user can copy and paste a row, the locked cell's value can be ignored.

View 9 Replies View Related

Row Adding With Formula In Protected Sheet

Feb 11, 2014

I'm trying to manage my Stock by using protected sheet, but i stuck with this "row adding with formula" stuff.

The user can only write in the colored cell, but everytime the user add new row, the formula doesn't copying by itself

I attach the file below with no password, if it's protected, the password is none, just press enter ( password : "" )

Book2.xls

View 5 Replies View Related

Two Tier Sorting In Protected Sheet

May 24, 2014

We are needing to do a two tier sort in a protected spreadsheet. Is this possible?

The two columns that need to be sorted have protected cells between them.

If there a way to ad a button that will automatically do this sort for the user... as in can I add a button some how in one of the empty cells that will do it?

Here is the sheet. [URL] ..........

Looks like I need to sort column A thru Z, except W.

View 1 Replies View Related

Insert Row On A Table In Protected Sheet

Dec 11, 2013

I am working on an excel table in my worksheet contains formulas and locked cells. lets say table range is from column "a" to "f" and there is formula on cell in columns "c" and "f". I just locked cells in column "c" and "f" to prevent people changing the formula accidentally. but when the sheet is protected i am not able to insert or delete rows as the rows has locked cells in columns "c" and "f".

I tried the below macro to unlock the sheet, insert row and lock the sheet again:

[Code] .....

So by running the macro it asks the password and do the job but the issue is it needs password and i do not want people to know my password. I don't want them able to unlock the workbook and make any undesired changes. I want them to be allowed insert or delete rows and input data in unlocked cell. I want the sheet to be locked all the time and only when people want to insert or delete a row it be unlocked and be locked again after inserting or deleting whit no need to insert password in this case only.

View 1 Replies View Related

Unable To Sort With Protected Sheet?

Dec 30, 2013

I have a sheet protected and filters enabled. I use this code to enable sort and filters:

[Code] ........

Nevetherless, when I try to sort, I receive this message in excel: "The cell or chart you re trying to change is on a protected sheet.

To make changes, click Unprotect Sheet in the Review tab (you might need a password)."

View 5 Replies View Related

Outlining Does Not Work On Protected Sheet

Feb 3, 2014

I am using Outlining on a sheet called "Today".The sheet is manually protected but now the outlining does not work as it says sheet protected.Is there a code i can use so that i can still have the Outlining working in a protected sheet.

View 5 Replies View Related

Changing A Protected Sheet From A Form

Apr 23, 2009

I would like to be able to add data to a protected sheet, only from a form without unprotecting the sheet first. Below is the code.

View 5 Replies View Related

Allow Formatting Of Font In Protected Sheet

Jul 9, 2009

I have a protected sheet. Under normal circumstances, once the sheet is protected, the facility to choose the font goes away. You can allow it by putting a check against 'Format Cells' in the protection dialogue. But then, the user can format all aspects of the cell.
What if I want the user to be able to format only the font (type and size) and nothing else in the cell or in a range of cells. Is there a procedure or VBA for that?

View 2 Replies View Related







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