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.
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
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.
