comments

Is there a way to format the comments page that you are going to print? I have the comments page set to print at the end of the worksheet. But I'd like to change the format of the comments page so there isn't so much space between each comment.

Can you deal with the comments in the attached? https://www.dropbox.com/s/uwuf9nht3snfva1/example%20-%20Copy%20%283%29.xlsx?dl=0

I wasn't sure I wanted to convert my old comments/new notes to new "threaded comments" when I first started using the latter so didn't agree to convert when asked by Excel, but now I cannot find a global convert option. Is there one?

I have set up a weekly log of my work, etc. Each day I enter in the amount of time spent on certain tasks. When I enter a number, I am prompted to write a brief explanation of the specific work I did. The explanations are stored as comments, which appear as I hover over them. Awesome! This is...

Hi, I have some VBA to take a path from the 2nd column and show an image for the cell that has been clicked using the comment box to display the image It looks great, hopefully others can use it if this error gets cleared up Example sheet <tbody> <tbody> <tbody> ML053 </tbody>...

Good evening, I'm struggling with this one. I have given my sheet user specific permissions to edit the range of cells. After protecting the sheet, all users are still able to edit comments. I want to restrict all users from editing comments, and allow only those who I gave "edit"...

I am trying to add a column to a score board, in which I can write custom comments which I want to appear as data labels on a graph (e.g next to June entry, "New manager starts" and such information I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option...

Hi I'm a newbie trying to update a spreadsheet that has 90 dropdowns, containing the same info: E P P/W PK There are two cells to the right of each dropdown: Time Comments When the user selects PK from a dropdown, I need the time to be inserted into the Time cell i.e 1430,1100 etc and the...

I'm trying to get the comments from the cells that are on another sheet to appear when my users hover over cell where drop-down list is. Please help, Mike in Cali...

Hi, I’m trying to get to grips with this Depth First Search algorithm I found here. Unfortunately as there are no comments and since I am still new to vba and programming in general, I can't follow what's going on. At the moment, I'm only somewhat familiar with If statements, some variables...

Is there any way, without a macro, to get Word to print the name with the comments rather than the initials (especially since it seems to put the inititals in backwords e.g. Tom Smith's inititials would show up as ST) And is there any way to make sure all the comments are printing as sometimes...

One of my workbooks at work has starting doing a strange thing, right after I protected one of the spreadsheets. I made it so that only a selection of cells could be edited, with the remaining unable to be even selected. When I copy and paste an identicle region of cells in another spreadsheet...

On my form there is a textbook which comments are written. I need it to save the comments every time the file is closed and when opened again the comments should appear. It should also save any editing done.

is there any vba code for inserting comments in a active cell and if a cell has already comments than show pop message that cell has already comments do you want to edit or no or delete comments. is there any vba code who can do this.

Dear Friends need help for VB code I am sending above referred file containing 500 plus records to almost 50 persons weekly for updating comments in column G and I (hatched in yellow) against each Job no (refereed Column A ) for they are responsible. I am sending file through mail to all 50...

I've looked all over but can't really find what I'm looking for. Basically I'm trying to build a VERY basic forum within Excel. Someone can post a comment, question, etc. Then other employees/Managers can respond. The problem is that it needs to be saved so that if a manager responds no one...

Hello Group! I have a Engineering Project Status spreadsheet. One of the columns contains a project number, which is comprised of the date (yy/mm/dd) and the customer number, like this: 180612-ABC000. The desired result: I want the customer name to appear when you mouse over the the project...

Hi everyone! I have a code I am trying to run, but it keeps showing this message: "Compile Error: Invalid use of property" _________________________ This is the code: Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 12 Then Sheets("Display TRT").Select Call Comments...

HI OK so I have a formula that pulls in cell contents from 2 spreadsheets into a 3rd spreadsheet based on date input. =IFERROR(LEFT(INDEX(Sheet1!$B$3:$M$20,MATCH($A17,Sheet1!$A$3:$A$20,0),MATCH(B$4,Sheet1!$B$2:$M$2,0)),1),"") So for any date input it will display the cell contents for that...

Hi All, Hoping you could help with my current problem I have with Power Query. I have a raw data file which is updated monthly. I use Power Query to split this raw data file into a number of workbooks based on the centre code as different members are responsible for their own centre codes...