| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
As soon as I protect my sheet, I can no longer insert comments...
As soon as I protect my sheet, I can no longer insert comments, even though
the cells are unlocked. I have allowed the user to format the cells when protecting the sheet. Argh! It is essential that comments may be added with a little red triangle in the cell to indicate that they are present. Any help will be very gratefully received! :o) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
As soon as I protect my sheet, I can no longer insert comments...
Hi,
Easy trick - When you choose Tools, Protection, Protect Sheet also check the Edit Objects choice. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Shelby" wrote: As soon as I protect my sheet, I can no longer insert comments, even though the cells are unlocked. I have allowed the user to format the cells when protecting the sheet. Argh! It is essential that comments may be added with a little red triangle in the cell to indicate that they are present. Any help will be very gratefully received! :o) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
As soon as I protect my sheet, I can no longer insert comments
Of course! I had interpreted that as allowing object such as other embedded
excel files to be edited which I don't want to happen. Brilliant! :0D "ShaneDevenshire" wrote: Hi, Easy trick - When you choose Tools, Protection, Protect Sheet also check the Edit Objects choice. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Shelby" wrote: As soon as I protect my sheet, I can no longer insert comments, even though the cells are unlocked. I have allowed the user to format the cells when protecting the sheet. Argh! It is essential that comments may be added with a little red triangle in the cell to indicate that they are present. Any help will be very gratefully received! :o) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INSERT COMMENTS INTO PROTECTED SHEET | Excel Discussion (Misc queries) | |||
| Insert Hyperlink shortcut no longer works | Links and Linking in Excel | |||
| Insert Hyperlink shortcut no longer works | Links and Linking in Excel | |||
| why can i no longer protect multiple worksheets in Excel | Excel Worksheet Functions | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
Linear Mode
