Sep 14, 2010 Can't insert new sheet into unprotected workbook I have a workbook that was shared and sent to me to update. I have unshared it and it is not protected however it will not allow me to Insert, Delete, Rename, Move or Copy, Hide or Unhide any sheets (options grayed out).
1 – Use a Line Break in a Cell with Alt+Enter A Potential Problem with Using Ctrl+Enter in Excel The line break is the character code 10. While invisible to the eye in Excel, this character may create problems when exported into a database system by prematurely starting a new record every time it’s encountered. Using Extra Spaces to Create a Line Break (Not Recommended) I’ve seen Excel users who don’t know about this shortcut so they try and make the lines wrap inside the cell by providing extra spaces between words. Adding spaces may provide a worksheet cell that looks nice and correct, but an export will also include those extra spaces. (See the formula bar below). Expanding the Formula Bar in Excel 2007 and 2010 The formula bar typically doesn’t show more than one line.
In the two figures above the formula bar has been expanded. You can do this with the keyboard shortcut Ctrl+Shift+U, which you’ll probably never remember, or you can select the drop-down arrow at the right side of the formula bar. Formula Bar for 2003 and 2008 This keyboard shortcut doesn’t work in Excel 2008 or Excel 2008 for Mac, and there’s no drop-down arrow at the right side of the formula bar.
When you encounter a cell with more than one line Excel automatically expands the formula bar. No manual intervention required. This is why some users are stumped after upgrading to 2007 or 2010 and finding they can’t see the entire cell contents in the formula bar.
I know I was. Dennis HELP.
I have a list of abbreviation & Acryonyms and the word(s) for that abbreviation. Can anyone help me with trying to get a new line into a formula? My currently formula is: =UPPER(B2)&”: “&B2&” is a data modeling abbreviation/acronym for “& PROPER(A2) “AI: ai is a data modeling abbreviation for Ab Initio” Examples (in 2 different columns): accept = acpt accounts payable = ar I need to create a title then a sentence. ACPT: acpt is a data modeling abbreviation/acronym for Accept.
——new cell—————– AR: ar is a data modeling abbreviation/acronym for Accounts Payable. ——new cell—————– etc. Marczewski Use vbNewLine (constant in VBA code – check Miscellaneous constants in VBA Help) – it is system dependent (different in Mac and in PC). However, it won’t work unless you set word wrapping in cell format (the same is true for line break inserted by using keyboard, e.g. Alt-Enter) – you’ll see this non-printable character as a small box (Win), with test wrapping on you get new line and no strange characters. Alternatively use various combinations of vbCr and vbLf to test/see what works for your system (of course text wrapping must be on), e.g.
Char(13) & char(10): function testCrLf testCrLf = vbCr & vbLf end function. Takioso Hi, I could not figure out, yet, how to produce cvs files that are suppose to contain several lines with in one value (cell). Actualy i usse java to export my csv-file, tat works fine, but without he ablility of giving excel 2010 the correct hint to have that certain values with new lines. Always excel thinks it would be a new row. I already tried using ‘ r’ instead of ‘ n’ wih in he value.
I am workig on a Windows 7 System can you give a woking excample record how it is supossed to look like? Thanks a lot in advance and best regards Takidoso.
Hello, i've got the following problem: I want users to double-click on a row on a protected sheet and then do some code based on the row-number of the clicked cell. I've protected the sheet because it contains a lot of formula's. When a user double-clicks a row it triggers the code through the WorkbookSheetBeforeDoubleClick event. After the code is executed Excel shows a message that the cell that was clicked was protected etc etc. How can I prevent this message from popping up?
I've already tried Code: application.displaywarnings = false but that didn't work Thanks. Hello, what I would like to do is take a portion of a sheet. So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39.
What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the 'proposal creation' sheet I want it to mirror only a specific cells to another sheet that is 'salesman copy' that we will print to clients. So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the 'salesman copy' which is what we will print for clients. Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.
I am running Excel 2011 for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions. I am trying to insert a range of cell in the body of an outlook email with the same format.
The code I am using now is below and it does insert anything in the email body. Code: Sub Mail Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject('Outlook.Application') OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail.To = '[email protected]'.CC = '.BCC = '.Subject = 'Burden Report'.Body = ActiveSheet.Range('A1:D12').Attachments.Add ('C: Documents and Settings cbelcher Desktop Burden Report.xls') End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing Set objMsg = Nothing End Sub. Hey there, I have been tasked with introducing userforms into an excel sheet and tbh I'm quite amazed that excel has this capability of adding userforms to excel sheets.
Anyway, I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. The user should then be able to select a particular row and insert it into the specified cell. I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected.basically so that the user can draw deeper into the information that they require. I have an example excel sheet where I have 2 sheets.
One sheet is the user entry sheet called User Entry Screen. The next sheet is the tables sheet where my tables are held. Once the user selects the cell shown in the example sheet, it should then bring up the user form. The user then, depending on which item clicked, then gets shown the next window with a table and info on it. Then user should then be able to select an item and the cells on the user entry screen would then get populated.
Personally I think this is a really tricky challenge and any help with doing this would be extremely appreciated. I'll post up further comments as I am trying to work my way through it!
Hello, As the title goes this is as simple as it gets. The macro worked good when I was using excel 2003 but now that I have 2007 everything works for except the resizing (Picture.Width & Picture. I am new to Excel and I am creating fillable forms in excel which are protected so that users canonly input data in certain cells. I am using Excel 2003. The users told me that they do not want text to go beyond the edge of the page when they are inputting data.
They also want the words to wrap when they reach the end of the sentence. I am also using check boxes(yes/no) and Ifind it difficult to make the adjacent cells fillable only Thanks for your help and correct me if I am wrong as I am new to this board. Hello, please help me out with this one. So I am at work workin on this report and I need a function that will make Excel automatically insert the today's date in a cell (let's say D90) when I fill the content of another cell (for example C90) and the that will be inserted will never change. I tried to use the =TODAY( ) function but it keeps updating the date in the cell to the current date if i reopen the worksheet 2 days later. I need the cell to keep in the cell the date of the day when I filled in the content of cell C90 and do not updated it every time i open the document to the actual date.
Thanks in advance!! Corporate edict. I have a worksheet that is locked and protected now, except for cells in a certain collumn. I have named the cells in that column 'MS96A'. If a user enters a date in a cell or range of cells anywhere in the column, the changed cells also need to be locked and protected (Once they enter a date, it is not allowed EVER to be changed again. Corporate requirement!
What I am looking for is this. If the user selects that cell again, they will get the usual pop-up message, 'The cell or chart that you are trying to change is protected.'
I think I am close, but I am getting an 'End If without block If' error on the If Clause. Sub WorksheetChange(ByVal Target As Excel.Range) Dim MRange As Range Set MRange = Range('MS96A') ' If Not Intersect(Target, MRange) Is Nothing Then For Each cell In MRange Sheets('Sheet1').Unprotect Password:='temp' cell.Interior.ColorIndex = 3 cell.Font.Color = vbBlack Selection.Locked = True Selection.FormulaHidden = False Next cell ActiveSheet.Protect Password:='temp'DrawingObjects:=FalseContents:=TrueScenarios:=False ActiveSheet.EnableSelection = xlUnlockedCells End Sub. I need help desparately.
Last night I spent several hours working on an Excel 2002 spreadsheet and it has disappeared. I saved it routinely as I was making many changes updates etc. I opened original file -stuff.xls - made changes and saved it as again as stuff.xls. I have done this several times before. Today, when I go to open stuff.xls, it is nowhere to be found!!!!! I have done a search, for any file modified since Thurs and nothing has appeared. I have checked the recycle bin, this did not go into auto recover nothing of the like.
I am just traumatized, because I have NEVER had anything like this happen before. I even thought perhaps I didn't save it as often as I thought, (I know that I did) but I remembered that I saved it at least once and I can't even find an Excel file that has been modified since Thurs!!!
Does anyone have any idea what could have happened to this file?? BTW, I have prayed, rebooted, run spybot, called witch doctor, all with no success. I have never had a file to just disappear with no trace. Any help would be greatly appreciated. Thanks in advance.