password protection in Excel
I have password protected an Excel worksheet but it can still be accessed
without using the password, and is therefore not protected! Any ideas? |
password protection in Excel
Hi Dona, When you set the password make sure you uncheck the box 'Allow Users to select locked cells'. Obviously the cells need to be formatted to protected. HTH Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=520986 |
password protection in Excel
Protecting a worksheet won't stop users from accessing that worksheet--but it
will stop them from changing locked cells on that worksheet. dona wrote: I have password protected an Excel worksheet but it can still be accessed without using the password, and is therefore not protected! Any ideas? -- Dave Peterson |
password protection in Excel
When you say 'Accessed' do you mean open it or change it. If you mean change it then my reply above applies. If you want to stop it being opened then use 'Save as' and apply the option to password protect it. Bear in mind that the Windows password protection system can be got around with a little knowledge -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=520986 |
password protection in Excel
Since the OP was writing about a worksheet (not a workbook), I read accessed as
view. EdMac wrote: When you say 'Accessed' do you mean open it or change it. If you mean change it then my reply above applies. If you want to stop it being opened then use 'Save as' and apply the option to password protect it. Bear in mind that the Windows password protection system can be got around with a little knowledge -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=520986 -- Dave Peterson |
password protection in Excel
Thanks,
that seems to be working OK now. I appreciate your help. Dona. "EdMac" wrote: Hi Dona, When you set the password make sure you uncheck the box 'Allow Users to select locked cells'. Obviously the cells need to be formatted to protected. HTH Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=520986 |
All times are GMT +1. The time now is 10:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com