Comments With Copied Worksheet

Jul 31, 2007

Using Excel 2007 I duplicated a worksheet by right clicking the worksheet tab and selecting Move or copy... with the Create a copy option. Of the six comments on the original worksheet only one appears in the duplicate.

View 2 Replies


ADVERTISEMENT

Code To Auto Input Worksheet Name From Data Copied From That Worksheet

Feb 23, 2014

I am copying data from worksheet "Microsoft" to another workbook and paste in sheet1, i want the cell G1 to auto input the worksheet name "Microsoft" where i copy the data from,

How to have G1 show the worksheet name after i copy and paste the data from worksheet name "Microsoft".

View 6 Replies View Related

Insert A Row In A Worksheet - Sheet 1 Is Copied Into A Second Worksheet?

May 29, 2014

when I insert a row into the sheet called WBS - Explanation, it only copies over into columns A:D in my worksheet called Timeline & Key Tasks. Unfortunately, I need the whole row to be inserted in the Timline & Key Tasks worksheet.

I can see how the coding has been set up and why this is happening, unfortunately I don't have the knowledge to workout how to change it to the code to include the whole row without deleting information, which I don't want to do.

View 7 Replies View Related

Add Copied Worksheet Name To Cell

Nov 7, 2006

original thread 2. Originally Posted by Dave Hawley

Private Sub Worksheet_Change(ByVal Target As Range)
Dim wSheet As Worksheet, wSheet2 As Worksheet
Dim strNum As String, strNum2 As String
If Target(1, 1).Address = "$J$5" Then
If Target = vbNullString Then Exit Sub
If IsNumeric(Target) Then
strNum = Target + 1
strNum2 = Target
On Error Resume Next
Set wSheet = Worksheets(strNum)
Set wSheet2 = Worksheets(strNum2)
On Error Goto 0
If Not wSheet Is Nothing Then
Application.EnableEvents = False
Application.Undo......................

What I would like to do is after the new sheet is created it would make cell j5 on the newly created sheet the same name as the sheet itself. I've tried to do that but the above code tries to activate. Is there a way to have the above code only work on the very first sheet and for the cell naming code to work on only the created sheets

View 2 Replies View Related

Cannot Remove Comments In Worksheet

Nov 6, 2008

I have a workbook that I received from a vendor that when I click in a cell a comment appears. There is no line or comment indicator for each comment. So I went into the tools - options - views - comments section and chose no comments. The comments still appear and when I go to the tool bar - view - comments nothing appears. I checked for any VBA code and didn't see anything. I was able to get around this problem by copy/paste special into a new worksheet, but curiosity is killing this cat.

View 2 Replies View Related

Turning On Comments On Worksheet

Apr 23, 2007

how to turn on the Comment Indicator through VBA? The code equivalent of setting Tools / Options / View and then selecting the Comment Indicator Only option.

View 2 Replies View Related

Userform Appears When Worksheet Is Copied

Jul 9, 2014

I have worksheets with different employees on separate tabs that are paid based on a compensation system inherent to their position and certain inputs. What I want to do is have a userform box appear whenever a worksheet is copied and allow the user to input the information unique to that employee (inputs are unique things like ID number, email, compensation rate, etc.). I know how to create a userform but how do I get it to automatically appear whenever a worksheet is copied?

View 4 Replies View Related

Option Button Name Changes When Copied To New Worksheet

Feb 2, 2007

I have two option buttons (Designerbutton1 & Designerbutton2), when I copy them and paste them to a different worksheet their names change to Optionbutton# (# = next available number). Anyone know why & if I can prevent this. I cannot have a code that says Optionbutton16 should be renamed to what I want it to, because right now 16 is the next available # but what if I add an Optionbutton16 later on my own.

View 2 Replies View Related

Adding Comments To A Protected Worksheet

Jan 20, 2010

I have (several) worksheets that have protection enabled. I have unlocked all the cells that users need access to and locked all the column and row headers/labels.
When I enabled protection on the sheets, the ability to add comments was taken away.
Is there a way to add comments to an UNLOCKED cell in a PROTECTED worksheet?

View 5 Replies View Related

Worksheet Change Removes Comments

May 11, 2007

I have an inventory sheet in which I am trying to accomplish two things:

1. Have comments pop-up when certain cells are selected that will explain to the user what kind of information he should enter. (So far, I have been able to make this work.)
2. When the user begins to enter information into the first of the aforementioned cells, a worksheet change event will automatically select the next cell for him, so that he will be immediately ready to enter information into it. That is, the worksheet will automatically "tab" over to the next relevant cell. (I'm having problems with this part.)

All in all, for each product on the inventory list, there are three cells that the user must enter information into.

Step 1: The ending inventory amount (the amount of product on hand).
Step 2: The user's initials.
Step 3: The time that the user physically counted the inventory.

(Then, when step three is done, the worksheet automatically tabs to STEP ONE ON THE NEXT ITEM. That is where I am failing miserably, although that is not the only place. . . . Keep reading.)

Here is my problem. I am not able to have my cake and eat it too. The comments are popping up beautifully, at the right time in the right way. However, when I enter the appropriate lines of code to make the worksheet change "tab" over the next cell, problems occur: the comments that provide instructions to the user do not stay visible. They flash for a split second, and then disappear. I am attaching a sample so you can see what I mean (and then I'm heading off to lunch with the boss, so it will be while before I can respond). The lines of code that I would like to have working are currently "commented out."

View 5 Replies View Related

Link/copy Value/formula To New Copied Worksheet

Jul 3, 2007

I have a worksheet. In sheet3 The value of column L2 is the value of column M2 in sheet . Everytime I copy the new sheet, I have to re type the formula for this new sheet. Is there a way to give formual such that when I copy new worksheet the formula will come automatically as it always has to link from the M2 column of the previous sheet?

View 9 Replies View Related

Insert A Line On New Worksheet With Copied Data

Jan 23, 2007

I need to add a line on the top of a new worksheet with the data copied from another worksheets cells. Using a macro. The line has to be created everytime on the top of the new excel sheet with the previous data moving one down.

View 6 Replies View Related

How To Copy Row To Last Row And Paste Copied Rows Directly Below Copied Contents

Oct 20, 2013

with a macro. I am looking to copy row 2 to the last row and past the copied rows directly below the copied contents.

View 9 Replies View Related

Copied Worksheet With Macros Still References Original Workbook

Oct 25, 2007

I have a workbook within which i have a worksheet that contains a lots of macro code (coded by me). As the workbook gets used by various people, i need to copy the worksheet and the macros across to the updated workbook, which doesnt contain the macro worksheet at all.

I have tried to copy it across by clicking on its tab and using the move or copy facility. This copies the sheet across as required. But for some reason, the macros all reference the old workbook. A small bit here for example for some reason opens up the old workbook and then performs the code in the old worksheet:

Sub SelectAll()
For i = 12 To 20
Set curcell = Worksheets("Form Generator").Cells(i, 3)
If curcell = False Then
Cells(i, 3).Value = True
End If
Next i
End Sub

As curcell is equal to worksheets...() i would have expected it to use the local worksheet, ie the one that the macro is attached to. So why is excel proactively hunting out the old workbook and sheet? is the method i used to copy across the sheet with the macros incorrect? If so, how should i go about it?

View 3 Replies View Related

Is There A Method To Globally Delete/remove All Comments From A Worksheet?

May 19, 2006

I'm attempt to automatically validate QTP spreadsheets with an EXCEL VBA macro. All is going well but I now want to look smarter. Is there a method to globally remove all comments from a worksheet?: D What I actually want to do is add comments to cells which fail validation but some of these cells may already contain comments. If they do contain comments then I want to overwrite with my comments. I thought the easiest way would be to delete all comments at the start of macro but I am all ears to any other approach.

View 4 Replies View Related

Prevent Copy / Paste Cells With Comments Or Allow Paste But Do Not Paste Comments

Feb 4, 2014

How would you prevent the copy/paste of cells that have comments?

Also, how would you allow cells with comments to be copied and pasted without pasting the comments?

I also have an aside question about the forum advanced search. When searching for multiple search words, how would you type the search to include all words, for example, "prevent" & "paste" & "comments".

View 7 Replies View Related

Add To Comments With VBA

Jul 11, 2005

I know that you can add a comment to a cell using a statement like

Range("A1").AddComment "Hello"
But is it possible to add more text to that comment using VBA?
I tried things like

Range("A1").AddComment "Hello."
Range("A1").Comment = Range("A1").Comment + " How are you?"
but I guess I can't alter the comment that way.

View 11 Replies View Related

Deleting Row After Copied

Nov 7, 2008

Just finished amending a piece of code to enable me to search for an agents name in a list of files. This is then copied to a new worksheet (named by the name entered in the search). What I need is to cut(or delete) the row from the original sheet (sheet 1 in this case) thus leaving me the remaining list of files.
Below is how the code is setup at the moment....(just copies the row)

View 12 Replies View Related

Where Do I Paste A Copied Udf

Jun 15, 2007

I have copied a colorindex UDF from here and went to VBE, inserted a new module in my Personal project, pasted the UDF and expected to be able to use it in any excel file. It's not working though. I have used this particular UDF before, but on a prevous computer that is not around for me to look at.

My goal is to use =IF(colorindex(J2)=colorindex($K$1),J2,"").

View 5 Replies View Related

Pictures For Comments

May 18, 2008

im using comments to display images for easy look up

when i save a picture i want it to be that size when i hovver over the comment

but when i insert the picture it doesnt open the size that i saved it as

i manually have to resize the image so its legible

why is this and is there a way round this?

View 13 Replies View Related

Add Comments In Userforms

Oct 30, 2009

I was wondering if there was a way to add comments (that you see in spreadsheets) on a userform in vb editor. So that when you run the form and the user moves the mouse over a textbox then it displays the comment.

View 2 Replies View Related

Disable Comments

Mar 3, 2008

I am sure this can be done - I found a similar thread but in a different context to what I need.

I have a user of a workbook who insists on putting irritating red cornered comments in cells, rather than using the handy (and rather large) comments field I put in, especially for her.

View 9 Replies View Related

Create A Comments Box Via VBA

Jul 26, 2008

I want to create a comments box whenever a cell is double clicked in sheet "Settlements"

View 9 Replies View Related

Alternative To Comments

Jul 30, 2008

For each cell, instead using a comment, I need another way to show a large amount of principaly letter texts, without using hypervincules, and ofcourse comments.

By the way, the same text I enter or modify put in this "way", I need to modify in the MSWord document and viceversa.

I appreciate the linking do not open another app, because the large amount of them I need to work with.

View 9 Replies View Related

Add Comments, No Spaces

Sep 22, 2006

I have a sub that works just fine, but I need to test it for blanks.

Sub AddToComment()
Dim rCell As Range
Dim cCom As Comment
Sheets("Support Detail").Select
With Range("e5")
.ClearComments
Set cCom = .AddComment
End With
Sheets("Sheet1").Select
For Each rCell In Range("a4:a23")
cCom.Text Text:=rCell.Text & " " & cCom.Text
Next rCell
End Sub

I only have 1 line of test in the a4:a23 range - so I'm getting 19 spaces before the text in the comment. If the cells within a4:a23 are blank, how do I ignore them? I'm not sure how to interpret this code, so I'm sure it's probably easy:

cCom.Text Text:=rCell.Text & " " & cCom.Text

View 3 Replies View Related

Rename File When Copied?

Jul 8, 2013

I just copied and modify this code; What I want is to add sumting on the file name, without changing, file path, original file name and file extension

Say : I get the file

D: DocsMemo.docx

I can paste it to the fnpath with a changed filename

C: \_Temp Memo_BPMC-0001.docx

Heres the code

[Code] .....

View 3 Replies View Related

Macro On Copied Sheet

Oct 16, 2008

Macro on copied sheet. I have a macro using the following to bring a shape to the front:

View 4 Replies View Related

How Can I Copy And Add A Row With The Copied Information?

May 19, 2009

I'm working on this sheet and i'd like to copy information from row "i,i", insert a new row below it and copy that information to the new empty row.

View 6 Replies View Related

Nested IF (data To Be Copied From Jan To Dec )

Aug 2, 2009

find the attached sheet. I want advice for the VBA Code I used in this sheet. I am simply using nested if. advice me any other solution for the same as I want data to be copied from Jan to Dec ? I am beginer in VBA coding.

View 3 Replies View Related

Protecting Spreadsheet From Being Copied And Used

Dec 7, 2008

I have a spreadsheet model I want to give to my students. I do not want them to be able to copy the spreadsheet.

Know of a product which can protect a spreadsheet from being copied and distributed to non intended users.

Something like "pairing" to a computers ID.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved