Hi,
I'm using Excel 2007 for quarterly reconciliations. Each sheet contains a quarterly reconciliation. Whenever I password protect a sheet within a workbook, it prevents me from changing data to the protected sheet. However, it does not prevent me from deleting the sheet.
How can I protect a sheet, and still prevent the sheet from being deleted?
Thanks for your help,
Paul
The protection menu has changed and I cannot protect just a worksheet. Only
"Protect Workbook" and "Protect and Share Workbook" options are available.
I am sending spreadsheets to collegues to add info and I want to give them the ability to hide columns in a protected sheet. Any ideas?
The cells they manipulate are interactive, but the sheets are protected.
Thanks.
Hi,
i have a workbook of 3 sheets "A", "B", and "C". i need a code to protect sheets "B" and "C" in a way to be not visible only if the pasword that is entered on sheet"A" is correct on cell F14 of sheet A(for ex)
also, i need to protect this vba code with a password.
I'm new in VBA ,, never written a code.
can someone help please.
thanks
Is it posiible to protectan Excell file from being saved by assigning a password?
I know how to password protect a file but this does not protect against the file being saved as a bew file name.
I want to protect some cells in a sheet so that I can just select and
blank the whole sheet while keeping the formulas in some cells intact.
The problem is that, having unlocked the editable cells and protected
the worksheet, when I then select the entire sheet it won't let me just
blank the unlocked cells - it tells me that some cells are protected.
Can anyone please help.
Morning All,
I have a large workbook with lots of spreadsheets, currently each individual sheet is protected as certain cells are locked on each sheet. Rather than having everysingle sheet protected is there a way to lock and protect them all at once?
Thanks
I have got one Excel sheet which is password protected some of the users know
the password , i dont want to allow these users to change some of the columns
of the work sheet..but it should be open for me..
I have a password protected spreadsheet which contains a macro that unprotects the sheet to input new info and then reprotects the sheet.. this process doesnt keep the password aspect of the process .. do you have any suggestions... i would need it to be the original password not one that the user selects as many people will be using this system??
any suggestions??
