Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Add comment in protected worksheet
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="trip_to_tokyo, post: 13886026"] EXCEL 2007 Yes. To achieve take the following actions:- 1. Home / Cells group / click on downwards facing arrow in Format / Protect Sheet / Protect Sheet window should launch / in here the following 3 fields should have a tick in them:- Protect worksheet and contents of locked cells Select locked cells Select unlocked cells 2. Add a tick to the following field:- Edit objects OK 3. To test try and enter data into any cells of the Protected Sheet (you should not be able to do this). 4. Shift F2 in any cell / comments pane opens / insert comment / click in another cell / comment goes in successfully. Save file. If my comments have helped please hit Yes. Thanks. [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Add comment in protected worksheet
Top
