Programming

Disable Copy
Is it possible to disable the copy and paste function without protecting sheets. Thanks Nick -- Nick S ------------------------------------------------------------------------ Nick S's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16512 View this thread: http://www.excelforum.com/showthr... 27 Jun 2005 10:08

Merge Two Spreadsheets into 1 new sheet...
Hi, Have never done vba/excel programming. Didn't know exactly what to search for. Been using vb6 for 7 years so vba won't be totally foreign if that is what is required. If I can use C# even better. Anyway... I have a client who has asked me to write a program for them that would take the data in ... 23 May 2005 19:30

CAN ANYONE SOVLE THIS PROBLEM!!!
HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).CodeModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE> HERE'S THE ERROR: " the object invoke... 17 Mar 2005 22:43

Microsoft Office Excel is waiting for another application to complete an OLE action
Hi, I'm developing a class which for a given filepath has to open the MS Excel and extend the context menu with a new item. When the item is clicked all it has to do is to display a message box. Everything works fine. But if the message box is not confirmed (closed by the user) in a few seconds the "Microsoft Of... 11 Mar 2005 14:59

Prevent Paste
Hi, Is there a way of preventing users from Pasting into a worksheet? Can I allow them to Paste values only? thanks Simon ... 1 Mar 2005 10:07

VBA and toolbars
Hi, Our product (which we ship as an xla) is controlled via a toolbar, which it creates on first run. In the module "ThisWorkbook" we have the following code: Private Sub Workbook_Open() Dim oCB As CommandBar Dim isthere As Object appMenu = "SavvyC" On Error GoTo create_toolbar Set i... 2 Mar 2005 10:31

Remove subtotal where only one item
Is there a simple way to format a pivot table such that when there is only one item to subtotal, the subtotaling is deactivated? In other words, given a specific field, I _do_ want subtotals to show if there is more than one item and _do not_ want subtotals to show if there is only one item color size ... 1 Mar 2005 10:07

Visual Basic and Excell
I have a spread sheet which has a single column of names in the format of Allen, Paul etc. Is there a way to write a macro using visual basic to create two columns, one for first name (Paul) and one for last name (Allen)? Column has about three thousand names in single column format. Appreciate your thoughts a... 27 Feb 2005 04:44

VBA Error: Method OpenTextFile of IFilesystem3 failed
I have a VBA macro on MS Excel that should open and read from a Text file. This is the code Dim fs, Tempfile Set fs = CreateObject("Scripting.FileSystemObject") Set TempFile = fs.OpenTextFile(strInputFile, 1, False) Do While TempFile.AtEndOfLine <> True ' Process Loop I found that it... 22 Feb 2005 18:14

data refresh all worksheets in a workbook using vba
I have set up a Database query and query will get data to populate all worksheets in a workbook. At the moment I have to go to each worksheet and press refresh data button to update. Is there a VBA code whereby I could refresh all worksheets in the workbook. Thanks ... 22 Feb 2005 18:14