A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Check the steps here:
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am unable to find the function " restrict permission" in my microsoft excel 2007 under the office tab but i can see that in the general options. Why is this so? I am also not able to use that function. Please help!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I encountered the same problem and am unable to restrict access. I can add the icons to the quick toolbar, but that is a far as they go and there is no functionality beyond that. Is there a difference in this functionality between Professional versions and Home and Student versions as I am using a Home version?
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
It is not grayed out. It is completely not there. However, I am able to find it in the excel options, under "all commands" . so when I add the command " restrict permission: into the Quick toolbar. It can be found at the Quick toolbar on my excel spreadsheet window. However, I am still not able to use that command. I tried clicking on it ("restricted accesss") , nothing happen (no wizard etc). i tried to click on the "managing credentials" too, nothing happen.
What's going on? Mine is a licensed Microsoft windows (Home version). Please help asap!
As you said ‘Restricted Permissions’ are under Office button > Prepare.
What happens when you try to use this function? Is it grayed out?
Provide more information on the issue.
Refer the article below which explains about restricted permissions in Excel 2007: