If ActiveCell has a comment then exit sub

[Claus Busch]

Hi Howard,

Am Tue, 13 Jan 2015 11:50:43 -0800 (PST) schrieb L. Howard:

Also, my archive system is not as good as it should be, because I was trying to find a "Comment Making" solution from you having to do with a weekly assigning Desk times, or Room Reservations for a number of people. It too used a UserForm and I know I have it in my archive.

oh yes, I remember.
Please have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "DeskBookings_2.0"


Regards
Claus B.

 

[L. Howard]

oh yes, I remember.
Please have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "DeskBookings_2.0"


Regards
Claus B.
--

Yep, that's it!

Howard

 

[GS]

Okay, this is all new ground for me and the OP is wanting to add,
edit or delete comments on a sheet, as easily as she can. She will
be the messenger with the code to her people and is at the edge of
Excel knowledge with the code I posted here.

I would be reluctant to step into this "new to me" UserInterfaceOnly
at this time on this macro.

Howard.

My point is that you don't have any error handling code in your
procedure! Sooo.., should an error occur then your sheet gets left
unprotected. Using my suggestion at startup obviates the need for extra
error handling code IN EVERY PROCEDURE where you toggle protection to
make changes. Otherwise, I suggest adding error handling!

Optionally, you can specify which sheets get protected and what level
of protection is applied to each sheet. The latter, though, is a bit
more complex than the simple code I exampled.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion