Forum home » Delegate support and help forum » Microsoft Excel Training and help » Permissions & protections
|
|
|
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. |
Permissions & protections
Resolved · Urgent Priority · Version 2003
Reply 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.
For upcoming training course dates see: Pricing & availability
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
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
Reply 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.
|