98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Permissions & protections
Permissions & protections
Resolved · Urgent Priority · Version 2003
Thu 21 Apr 2011, 16:10Delegate Cecilia said...
Cecilia has attended:
Excel Advanced course
Permissions & protections
I developed a 5(linked worksheet) workbook but seems to be locked out of one of the sheet by some sort of protection.
Thu 28 Apr 2011, 08:57Trainer Simon said...
RE: permissions & protections
Hi Cecila,
Thank you for your question.
Do you mean you have one workbook with 5 sheets that are all linked and when you click on the sheet in question it doesn't appear?
What was the exact message you get?
Have you tried the following?
1. When you go to Tools and Protection, is there a menu option that says 'Unprotect Sheet' or 'Unprotect Workbook'?
2. Do you know if there is any VBA code in the Visual Basic Window as you can write code to protect sheets as well?
Regards
Simon
Wed 18 May 2011, 10:51Trainer Simon said...
RE: permissions & protections
Hi Cecilia,
Could you please let me know how you got on after trying my advice from my forum response.
Is this now resolved?
Looking forward to hearing from you.
Regards
Simon
Thu 19 May 2011, 15:36Delegate Cecilia said...
RE: permissions & protections
The suggestions did not solve the problem. I have had to design a new spreadsheet without protection. As I don't have knowledge of VB yet, I obviously need to find a way to protect the spreadsheets and permit levels of usage but that is a matter for another day.
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. |
Excel tip:Display developer tab - Excel 2010a. In Excel, click on the File tab |
