problem in watching the comments tags when making protection to sheet
 

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well

problem in watching the comments tags when making protection to sh
 

Are you adding the comment with VB ?
I obtained this code by simply recording a macro and this is what was
generated. It should give you an idea of how to add to your code.

Range("C7").Select
Range("C7").AddComment
Range("C7").Comment.Visible = False
Range("C7").Comment.Text Text:= _
"This is a test of how to add a comment to a cell"

"thread" wrote:

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well

problem in watching the comments tags when making protection to sh
 

the problem is not making the comments as its already there,
the problem is that the comments are not visible when the sheet is
protected
Rich J כתב:
Are you adding the comment with VB ?
I obtained this code by simply recording a macro and this is what was
generated. It should give you an idea of how to add to your code.

Range("C7").Select
Range("C7").AddComment
Range("C7").Comment.Visible = False
Range("C7").Comment.Text Text:= _
"This is a test of how to add a comment to a cell"

"thread" wrote:

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well

problem in watching the comments tags when making protection t
 

Are the comments you are referring attached to a cell and have the red
triangle in the corner and appear when you pass the cursor over them ?
I'm not sure what the protection has to do with seeing them. If you want
them visible automatically then put this line in for each comment you want
visible when the macro is run -

Range("C7").Comment.Visible = True

You will need another macro with all set to False to hide them.

"thread" wrote:

the problem is not making the comments as its already there,
the problem is that the comments are not visible when the sheet is
protected
Rich J כתב:
Are you adding the comment with VB ?
I obtained this code by simply recording a macro and this is what was
generated. It should give you an idea of how to add to your code.

Range("C7").Select
Range("C7").AddComment
Range("C7").Comment.Visible = False
Range("C7").Comment.Text Text:= _
"This is a test of how to add a comment to a cell"

"thread" wrote:

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well

problem in watching the comments tags when making protection t
 

Hi,
i found a solution in the protected command:
objectview=false
Rich J כתב:
Are the comments you are referring attached to a cell and have the red
triangle in the corner and appear when you pass the cursor over them ?
I'm not sure what the protection has to do with seeing them. If you want
them visible automatically then put this line in for each comment you want
visible when the macro is run -

Range("C7").Comment.Visible = True

You will need another macro with all set to False to hide them.

"thread" wrote:

the problem is not making the comments as its already there,
the problem is that the comments are not visible when the sheet is
protected
Rich J כתב:
Are you adding the comment with VB ?
I obtained this code by simply recording a macro and this is what was
generated. It should give you an idea of how to add to your code.

Range("C7").Select
Range("C7").AddComment
Range("C7").Comment.Visible = False
Range("C7").Comment.Text Text:= _
"This is a test of how to add a comment to a cell"

"thread" wrote:

Hi all,
i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well