Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotecting a spreadsheet
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Unprotecting a spreadsheet
Resolved · Low Priority · Version 2003
Reply Wed 28 Oct 2009, 16:24Delegate Dee said...
Dee has attended:
Excel Advanced course
Excel Intermediate course
Unprotecting a spreadsheet
I am working with a large spreadsheet that at one point I must have protected in some way, as I am not allowed to delete four of the worksheets. I don't remember what exactly I did, as it was quite some time ago. The sheets really do need to be deleted.
Is there a limit to the number of sheets that you can have for a single Excel page? I don't know if its related to my problem with not being able to delete the worksheets or not, but when I go to the Insert (at the top) and look to add a worksheet, it is not available as an option (grey instead of black).
Any advice?
Cheers,
Dee
For upcoming training course dates see: Pricing & availability
RE: Unprotecting a spreadsheet
Hi Dee
Thank you for your question
For starters, click on the tools menu and select protection. If you have protected it, then you will be given the option to unprotect the workbook.Select this (Entering any required password) and you should be fine.
If this is not the case, let me know and I will explore other options
Regards
Stephen
Reply Fri 30 Oct 2009, 16:54Delegate Dee said...
RE: Unprotecting a spreadsheet
Thanks Stephen, it worked a treat!
Dee
|