Indenting Disabled when Sheet is Protected
I am currently developing a spreadsheet for my company, where I would like to
protect users from inserting and deleting rows and columns. However, once I protect the sheet, even when I allow users to format cells, the indent buttons do not work. Is there a way to protect a sheet but still allow users to do this, other than manually formatting each cell by going through drop down menus? |
Indenting Disabled when Sheet is Protected
In Excel 2007 when I protect the sheet and allow formatting of cells, the
left, center and right justify buttons in the alignment group on the ribbon work but the indent buttons do not work. When I go to the format cells dialog (Ctrl+1), I can indent the cells there in the alignment tab. Interesting. Tyro "sneary" wrote in message ... I am currently developing a spreadsheet for my company, where I would like to protect users from inserting and deleting rows and columns. However, once I protect the sheet, even when I allow users to format cells, the indent buttons do not work. Is there a way to protect a sheet but still allow users to do this, other than manually formatting each cell by going through drop down menus? |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com