Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection problem | Excel Discussion (Misc queries) | |||
Calendar problem with sheet protection? | Excel Programming | |||
Making comments apply to more than one cell | Excel Discussion (Misc queries) | |||
Bill is watching your posts | Excel Programming | |||
sheet protection problem | Excel Programming |