I used following vba for comment based on cell value, but when sheet is protected its not working (message .. Run time error '91': prompting for debug)
Please Login or Register to view this content.Please Login or Register to view this content.please guide where I am wrongPlease Login or Register to view this content.
Last edited by AliGW; 07-18-2018 at 02:10 AM. Reason: Code tags amended.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
To be strictly correct since there are several discrete procedures you should have wrapped each one within its own CODE tags.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Can you modify it. I don't know vba just copy pasted from someehere.
This is nothing to do with Excel or VBAOriginally Posted by anil.kut
This is all about how you present information in the forum. We require code to be surrounded by code tags since it makes reading it much easier. We don't care where you copied it from. We do care that you take the trouble to select the code in the forum post and click the # icon to create the tags.
I did it for the OP this time, but you are right, Richard: if the OP wants us to spend time on his query, then he needs, at the very least, to be prepared to present his posts in the way we expect them to be presented. I would not wish to accuse him of laziness in this thread, but post #4 does not fill me with confidence!
Hi AliGw,
I think there is something lacking in my post. If you can tell me I can correct.
All I wanted that the comment in a particular cell should take content from some other dynamic cell and this should hold good in protected sheet too.
Thanks for support.
Add code to unprotect the sheet, change the comment, then reprotect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks