Security - Protecting A Paticular Sheet Only

Jan 7, 2009

i have produced a spreedsheet on ms excel.

On sheet 2 is all of the information and tables etc.. for example prices and information for the combo boxes an such...i need to protect this sheet so no one can change anything on it

the problem is when i do so, and go back onto sheet 1 and say tick a checkbox or select something from the combo box is doesnt allow me to, the protection message comes up

i dont want this to come up on sheet 1, only on sheet 2!

i think its because i have links between the pages? like all of the info for the combo box is on sheet 2

View 9 Replies


ADVERTISEMENT

Protecting A Sheet ..

Mar 24, 2008

I have a Sheet with some Macro Buttons for the boss to use.
How can I protect the sheet from any Data Entry changes, but still allow the Buttons to be used?

I tried a few scenarios and in all, the Buttons can't be used.

View 9 Replies View Related

Protecting Sheet ...

Jul 30, 2009

I have a sheet and want users to be able to type in a set of cells but not able to move the cell how do i do this?

View 9 Replies View Related

Changed Security Setting On Excel Sheet Now Can't Find It

Aug 13, 2012

Iv changed the security settings to my name (along with admin) and removed 'everyone'.now when i go into my folder, everyone else's excel sheet is there but mine has gone.

is there a way i can get it back?

View 1 Replies View Related

Protecting A Sheet From Deletion

Mar 26, 2007

I have a workbook with particular worksheets that should never be deleted. If they are deleted by the user the workbook will become unusable.

The users need the freedom to edit data within the sheets (so protecting them is not an option), however, I need to restrict this freedom so that they cannot under any circumstance delete the sheet. Is there such code that I could use in the worksheet code to stop this?

View 12 Replies View Related

Protecting Very Hidden Sheet

Dec 6, 2006

way of protecting a very hidden sheet, I will still need to open the sheet myself everytime I use the program. The only person to open this very hidden sheet is myself.

View 9 Replies View Related

Protecting And Unprotecting A Sheet

Oct 2, 2008

I want to run a macro that puts information from one sheet into another. The destination sheet is protected so I want to unprotect the sheet, do the copy and pasting then reprotect the sheet. The sheet has a password and I can't work out how to put that into the macro. It works fine without a password.

View 9 Replies View Related

Protecting Parts Of A Sheet.

Dec 20, 2008

I am going to use Excel sheets as computer exam forms. What I need to know is: Is there a way of protecting parts of an excel worksheet from alteration? I want a sheet that will accept answers in specific areas only, and will not accept entries or alterations in other areas.

View 9 Replies View Related

Macro For Protecting A Sheet

Dec 23, 2009

Excel 2002

I have a sheet that has some cells already protected by a password. I want another person to be able to make changes to the unprotected cells and then be able to push a button (macro) that will then unlock the sheet activesheet.unprotect ("mypassword"), change all the cells to "locked" and then have the protect sheet window pop open so that they can type in their own password and save it. Is that possible?

View 9 Replies View Related

Protecting Data When Extracting From Another Sheet

Feb 17, 2010

I need is for the Roster sheet, which has the exact same column and row headings as the Leave sheet, to read the data from the Leave sheet and change dynamically if the Leave sheet is changed. If there is data in any cell then I need to protect just that cell in the Roster sheet so that the user creating the staff roster is unable to edit it out.

I have created a plain cut and paste macro on open from Leave to Roster but this doesn't give me the dynamic linking, and doesnt help solve the problem of needing to check each and every cell in Roster against a corresponding cell in Leave, but also if its blank in Leave to allow the user to update that cell in the Roster sheet.

View 3 Replies View Related

Protecting Sheet With Limited Access

Sep 26, 2013

I need to protect a sheet with following access to users.

1. data can be entered in column a only... rest is automatically updated with formulas

2. users can insert/ hide rows. but can not delete any rows and can not hide/ insert/ delete columns

View 4 Replies View Related

Protecting A Spread Sheet From Being Forwarded

Oct 27, 2009

Is there a way to lock out a spread sheet if it is sent to an unauthorized e-mail address or forwarded to another e-mail address?

View 9 Replies View Related

Locking Cells And Protecting Sheet

Feb 14, 2007

A1 is number of days available
this sheet goes to a routing recepient from me who fills A2 and B2. C2 and D2 are calculated.
A2 has starting date
B2 has ending date
C2 is days between these two dates
D2 is number of days left i.e. A1-C2

I want to lock and protect cells A2,B2,C2 and D2 so that these cannot be changed when I route it back to get next set of dates to be filled by the same person.

View 3 Replies View Related

Macro For Protecting Sheet (with Same Name) On Multiple Files At Once?

Jul 19, 2014

I have a macro that duplicates a excel file into how ever many files I need... so If I need 150 copies of the the file, it will make it 150 times.

However, each file the first tab called "Clients" has information that I want protected so users can't alter it. I can't protect it before I run the duplication because the data is added by a group of people and I need it unprotected until they add the information.

What I am looking for is a macro that I can click and run, allows me to select multiple files, then it will automatically Protect Sheet 1 "Clients" on all the files I select so I don't have to open all 150 files after data is entered and Protect sheet 1 manually.

View 5 Replies View Related

Protecting Data Sheet But Able To Use FrontEnd Userform

Dec 11, 2011

What is the best way to protect a Data sheet, but still be able to use a FrontEnd Userform.

View 4 Replies View Related

Macro To Prompt For Password When Protecting Sheet

Nov 12, 2009

Macros are just not my strong suit. I can usually find my answers here but this one has me stumped. I have rewritten this thing everywhich way but loose and this is my latest version.

Sub SetProtect()
'
' protect Macro
' prompts for password protection
'
' Keyboard Shortcut: Ctrl+p
'
Dim Response As String
Dim Answer As Integer

SetProtect:

Response = InputBox("Enter password")
If Response = "safety2" Then.......

View 9 Replies View Related

Macro Security (saying That The Macro Security Level Is Too High)

Nov 18, 2008

I have a sheet that will not let me use macros. I can record them, but when I go to use them it says that the Macro security level is too high. I change it to Medium or Low but it doesn't make a difference.

The same spreadsheet works with Macros on another computer, but not my main one.

View 5 Replies View Related

Are You Sure - Security For Macro

Aug 7, 2007

I have a spreadsheet that I regularly have to clear the data and start over on, so i recorded a macro for clearing this rather long sheet with only one cllick.

My problem is that i am not the only person who will use this sheet, if They click the control button by mistake they will clear their work and you cannot undo it. I was wondering if i could make it ask "are you sure" kind of like the save option when closing an unsaved document.

View 11 Replies View Related

VBA Security Options

Oct 12, 2009

We have developed an Excel workbook with hundreds of lines of VBA code written for a specific application, and we would like to protect it.

Could someone give me an idea of what security options we have over and above the below (if any)?

We have protected all sheets and the workbook itself with passwords. The VBA itself is protected with a passoword.

My understanding is that VBA can be hacked into quite easily.....is there any way of adding another layer of security/protection without having to move to another platform altogether?

View 6 Replies View Related

VBA Module Security

Dec 17, 2008

i am going to ask is for my curiosity only and to be sure that no one will break my password.
If the VBA module is locked for viewing and password protected, it can't be cracked??I asking this, because i made an excel application with macros, and i don't want the user of it to crack my password.
I have to mention that the password is 17 letter+spaces long.
I repeat again....i asked this ONLY for my application safety.

View 9 Replies View Related

Macro Security

Jun 29, 2006

If there is code attached to a worksheet, not necessarily in a macro, does the macro security still have to be low to use it??

View 3 Replies View Related

Security Code Input

Dec 7, 2009

If I have a cell which has been validated and has a drop down list of 4 names in it.
I need it to prompt the user that when they choose there name and select, a window pop up or similar window appears asking for a 4 digit(or similar) code.

This is to stop others using peoples names against jobs they have completed so there is accountability if there are issues with information.

For each line I need it to re-prompt the user to enter the 4 digit pin so it cannot be tampered with.

Can anyone help with sending through a form and VB code possibly which I can copy into my spread sheet or a method I can use!

View 14 Replies View Related

Social Security Number

Sep 8, 2009

if there was a way to block out the last for digits of the social security number? list of numbers are in d4-d20

Ex

123-23-5785

would be

123-23-XXXX (with X's)

or how ever is supposed to be i forget the (standard) format

XXX-XX-5785

View 9 Replies View Related

Cell Value Security Check

Apr 10, 2007

There are 2 cells on my spreadsheet where individuals must populate $ values. I want to put a security feature in the worksheet that would create a pop up warning to the user that one cell must be greater than the other.

B26 (Client Assets) must be greater than B41 (Dollar Impact), otherwise a dialog box pops up to indicate to the user that B41 cannot be greater than
B26.

View 4 Replies View Related

Security Against Password Hacking

Dec 12, 2007

Is there a way to make excel less vunerable to hacking? We have a customer who is always breaking in and changing things.

View 4 Replies View Related

Security Warning (Macros Have Been Disabled)

Apr 28, 2008

I was playing around with Macros on an excel file. I created a few and ran them. In the end, I didn't like the way they ran, so I deleted them all. However since I ran them in the excel file, every time I open the file it gives me a warning saying
"Macros have been disabled."

Is there any way to remove the possible Macros ties/links from my file? I know I can disable the warning, but if I just want to remove the Macros ties to my file.

View 10 Replies View Related

Security Warning When Workbook Opened

May 30, 2009

my workbook is finally working the way it should but every time i open it i get a security warning window with the options disable macros, enable macros and more info. how do i get this to not show up every time it's opened. this workbook will be used by someone other than me and i don't want them to need to do anything but open it and use it.

View 8 Replies View Related

Turn Off Security Warning Regarding Macros

Jun 2, 2009

I would like the security warning not to pop up when the workbook is opened. I have been able to turn it off for myself but I had someone else test it and each time it's opened the security warning pops up with the disable, enable messages. Is there a way to turn this off permanently so not matter who opens it it won't pop up?

View 9 Replies View Related

Macros Dont Work Even On Low Security

Aug 21, 2009

My dad wrote me a VB programme to save me time entering repetitive data into an excel template for my business. At first it didnt work untilll i reduced security to low. Sice then I fried my computer and have had to reformat it with a diffirent version of windows, vista service pack 3. Now even on low security it doesnt work.

The little button in the worksheet to make the macro happen isnt visible or doesnt exist.

View 13 Replies View Related

VBA To Determine If Federal ID Or Social Security #

Jan 29, 2010

What would be the simplest VBA to determine if a cell E7 contains:

A federal ID always 9 digits with only one hyphen which is always after the 1st two numbers. For example: 12-3456789

or

A social security number always 9 digits with only two hyphens which are always 1 hyphen after the 1st 3 numbers & the other hyphen after the next 2 numbers. For example 123-45-6789.

In other words,

If Range("E7") = a federal id then
or
If Range("E7") = a social security number then

View 10 Replies View Related







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