excel shared run-time error 1004 Conklin New York

Address 225 Harrison Ave, Endicott, NY 13760
Phone (607) 821-1982
Website Link http://www.facebook.com/thetechcellar

excel shared run-time error 1004 Conklin, New York

How would they learn astronomy, those who don't see the stars? This riddle could be extremely useful EvenSt-ring C ode - g ol!f UPDATE heap table -> Deadlocks on RID House of Santa Claus Exploded Suffixes What does a well diversified self-managed I believe my problem might be in the following code: Please Login or Register to view this content. Why would this appoach not appeal? --- Regards, Norman "Nigel" wrote in message news:[email protected] > > Hi > > I have a small excel estimate form which needs to be

Helpful Excel Macros Automatically Run a Macro at a Certain Time - i.e. Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Sandeep You can post sample data using any one of the following ways: 1. We have had everyone log out of excel to clear it up, but it is still giving us that same error. TH Going to be away for 4 months, should we turn off the refrigerator or leave it on with water inside?

Register Help Remember Me? Now if there is one user on the network who is using the shared workbook, there can be data corruption. 1.How can i write a macro so that i 'kick' out If you could give me a script example it would be a great help. Data may need to be entered by 2 people at the same time so it has to be shared and to expect them to manually cut and paste when the form

And what about "double-click"? Would this code conflict if I have 2 copies of the same workbook up at the same time and try to run this code in one? The macro in question is "GSEmail". more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

Here's the code: Code: Sub SaveHistoryLog() With ActiveWorkbook .HighlightChangesOptions When:=xlAllChanges .ListChangesOnNewSheet = True .HighlightChangesOnScreen = False End With Sheets("History").Select Sheets("History").Copy Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:="Sharing testing 2 history.xls" Application.DisplayAlerts = True I've tried Code: on error resume next Do activeworkbook.save loop until activeworkbook.saved = true but that doesn't work. You do not need any .SmallScroll commands and if you got out of the .Select method in favor of direct cell/sheet addressing it looks like it could be written in less Ian posted Oct 13, 2016 at 10:43 AM Loading...

When finished I simply print the form off and want to return the form back to its original size with all the entered data removed. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. You will be a Similar Topics Run-time Error '1004': Macro Error, Only When Shared - Excel Sharing Workbook Causes Error 1004 - Excel Problems With Vba Code When File Is Shared Share Share this post on Digg Del.icio.us Technorati Twitter Richard Schollar Using xl2013 Reply With Quote « Previous Thread | Next Thread » Like this thread?

is there any alternative i can use? –user2810094 Jan 22 '15 at 12:37 thanks @Jeeped but is it related to my question? End With myWorksheet.protect contents:=True, userinterfaceonly:=True ... When I try to execute the macro, while shared i receive Quote: Run-time error '1004': Application-defined or object-defined error. Make space between rows constant In the United States is racial, ethnic, or national preference an acceptable hiring practice for departments or companies in some situations?

Not the answer you're looking for? it's a modern post apocalyptic magical dystopia with Unicorns and Gryphons Why does argv include the program name? (KevinC's) Triangular DeciDigits Sequence How to make files protected? Ask Questions for Free! Worked exactly as expected.

As a possible alternative to the insertion of entire rows, perhaps you could have differently sized templates on hidden sheets and use a button's click event to replace the used form The intention is that it would be used very frequently by lots of different people in various parts of the building. You'll be able to ask any tech support questions, or chat with the community and help others. The shared excel file is manipulated by another excel file using macros.

It looks like whoever created the workbook , wanted to protect some areas on each worksheet and let the user enter info in the un-protected area...which menas that the workbook cannot Ran macro from button, got "Run-time error '1004': Method 'ListChangesOnNewSheet' of object '_Workbook' failed (I've also seen "Method 'HighlightChangesOptions' of object '_Workbook' failed). I > recorded a macro which again is fine in unshared mode but returns a > runtime error when shared. > > Keyboard Shortcut: Ctrl+l > ' > Range("b10..h10").Select > Selection.Insert I can't post the workbook because of confidential info.

This workbook is shared by multiple users and is protected. Any help really appreciated. within the Excel Questions forums, part of the Question Forums category; When running a macro to insert a new line in a table I get runtime error '1004' - application or Its so frustraiting as I didnt realise the restrictions effecting a shared workbook when I set out on my project.......so I suppose if nothing else Ive learnt something!

same thing happens Also. Added a button from Control Toolbox and set it to run the macro. some code to present the error message to the user SkipErrorHandler: End Sub Edit: Have a look at this thread at PCreview. Now, I have created some macros to ease up the tasks in the workbook.

Share it with others Like this thread? Copyright © 2012 TextNData.com. Thanks again Nigel Register To Reply 08-01-2005,02:40 PM #9 Nigel View Profile View Forum Posts Forum Contributor Join Date 07-28-2005 Posts 126 Norman u still there? Anyone have any bright ideas?

Ask Your Own Question File No Longer Shared Issue - Excel Excel Forum Hi, I am trying to share a workbook but am getting a 'File No Longer Shared' error: I Edit: Thanks to Lance Roberts for his recommendation to use Workbook_Activate instead of Workbook_Open. When I share the workbook on a network I get the following error: runtime error 1004: subtotal method of range class failed. Loop through All Worksheets in Excel using VBA and Macros Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros.

I seem to only get the error message when I have 2 copies of the same workbook open at once. Is the NHS wrong about passwords? Search Excel Forum Posts, Tutorials, Macros, Tips, and More New Excel Help Service! I know this is a very vague question, but I'm stuck here and as far as I can see...

When must I use #!/bin/bash and when #!/bin/sh? We have a shared workbook which was 2000 but has been saved in Excel 2007 format but now when the workbook is opened we get the message that it is locked Meaning of S.