Controls in protected sheet don't response!!! Hi, Geeks!! 1. Can any one tell me if it is possible to activate the controls in the proctected sheet? One of the control has to delete the rows. I can't!! 2. Any idea to reduce the security level to low through VBA in Excel 2003!! 3. How to protect the sheet from being deleted? I need a VBA code to do this. ... 14 May 2010 08:25
ThisWorkbook.Name returns a wrong workbook name I am using Excel 2003 and an addin I have written. When I use ThisWorkbook.Name in my code, it returns the name of the addin, not the name of the workbook I have open. How can I get the name of the workbook, not the addin? Many thanks. ... 14 May 2010 03:01
ThisWorkbook.Name returns a wrong workbook name I am using Excel 2003 and an addin I have written. When I use ThisWorkbook.Name in my code, it returns the name of the addin, not the name of the workbook I have open. How can I get the name of the workbook, not the addin? Many thanks. ... 14 May 2010 08:25
Upload data on sharepoint automatically. Hi, I have some pdf files in a folder which I want to upload on sharepoint with the help of Excel VBA code. Sharepoint doesnt have a check-in process. It will be great if some one can help me with this. Regards Heera Chavan ... 14 May 2010 11:43
Excel Hi, I want to know how can I increase file size with out putting too much data into it. I just want to increase the file size by updating only 10 or 20 cells in the sheet. Regards Heera Chavan ... 14 May 2010 07:21
streaming data into excel Hello everyone :) I hope someone could help me. There is stock data on a website which I would like to stream live into my excel file. When the worksheet refreshes, I would like the new data to be posted in a row above the old data. I am not an excel genius, though I have been able to stream data into excel... 14 May 2010 10:37
how to print autocad dwg's from excel vba If I have a dwg # in a sheet cell, how can I print that dwg. from excel vba. This is as far as I got: (I need help with the last 3 lines) Sub print_dwg_from_excel() A = ActiveWindow.ActiveCell.Value B = Dir("c:\AUTOCAD\" & A") C = "c:\AUTOCAD\" & B Set fs = CreateObject("SCRIPTING.FILESYSTEMOBJECT") Set f = fs... 14 May 2010 03:01
Help with this code please !!!!!!! I have use the code set below in other files but in this new file I am getting an error on "Cells.Select". "Select method of Range class failed" Any idea whats going on? Sheets("Completions Summary").Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.C... 14 May 2010 00:52
How to select a workbook? I open two workbooks at the same time, and would like to setup a macro to select workbook "mybook.xls", and bring it into the upfront. Does anyone have any suggestions on how to do it in execl? Thanks in advance for any suggestions Eric ... 13 May 2010 23:47
selection.copy = "picture too large" excel 2007. I understand this has something to do with office clipboard changing all copied stuff to picture format? I found one hint to turn off office clipboard but it didn't work. what now? John ... 13 May 2010 22:41 |