user add cell comments in protected sheets

mweaver

Board Regular
Joined
Jul 28, 2002
Messages
129
Greetings from Salina, Ks,

I have a worksheet for other users in our office that is worksheet protected for obvious reasons. Complete access to the worksheet has proved fatal. We keep the worksheet protected to maintain the formulas & formatting.

This protection disables the users ability to add cell comments which would be very helpful in this worksheet.

Is there simple code to create a macro that would :

1. password unprotect worksheet

2. Prompt user for cell comment

3. Password protect sheet upon completion of user entering cell comment?



Any help would be appreciated.

mweaver
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Shouldn't be too traumatic, but a couple of questions:

- I guess you imagine something like users select the fell they want to comment, then click a button or something to get a box where they enter text that becomes the comment?

- can users comment a cell twice?
- if so, what happens to the previous comment
- if so, do you want to record the name / id etc of the user adding the comment
- can users delete comments?

Paddy
 
Upvote 0
PaddyD;

Thanks for the response!

Multiple cell comments and user deletion would be OK for this worksheet. Recording Id would be nice but not really necessary.

This worksheet is not really shared. Each user has individual copies but cannot seem to be trusted to leave formatting and formulas alone. The comments would be personal notes regarding cell entries to allow the user notation for why he did-- what he did 20+ days later.


any help would be appreciated.


Thanks PaddyD

mweaver
 
Upvote 0
Hi there
If your sheet doesn't contain objects, try protecting without checking the objects box.
regards
Derek
 
Upvote 0
On 2002-09-03 19:54, Derek wrote:
Hi there
If your sheet doesn't contain objects, try protecting without checking the objects box.
regards
Derek

Well spotted Derek - don't I feel silly now!
 
Upvote 0
Don't worry Paddy, I have been filching plenty of good ideas from all your posts.
regards
Derek
 
Upvote 0
Thanks Derek!

That is Wonderful... but .... This worksheet contains objects which must be protected!

mweaver
 
Upvote 0
Bugger, another simple, elegant solution shot down by the messiness of the real world!


Anyway, how's your coding?

see here:

http://mrexcel.com/board/viewtopic.php?topic=19869&forum=2

which will need a textbox to take the comment string instead of picking it from a cell. All of which can be inserted into something like:<pre>
Sub Comments()

Dim WS As Worksheet

WS.Unprotect "password"

'comment code here

WS.Protect "password"

End Sub</pre>

paddy
This message was edited by PaddyD on 2002-09-03 20:36
 
Upvote 0

Forum statistics

Threads
1,219,006
Messages
6,145,711
Members
450,635
Latest member
Rookie3510

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top