Reports: · Posted 8 years ago Top Topic Closed This topic has been closed to new replies. So the problem is older than the Add-in you downloaded? Suggestion 2: explain what the purpose of the code is, since it doesn't seem to work even with ws.Select suppressed. Application.Commandbars.Reset Best Regards, Asadulla Javed, Kolkata --------------------------------------------------------------------------------------------- Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.
exerguy, Dec 3, 2008 #7 bomb #21 Joined: Jul 1, 2005 Messages: 8,284 It ought to work for visible and hidden sheets. There should be a restore point from just before you downloaded the Add-in (or was that a long time ago?). It's unlikely anyone will be able to help you unless you post a copy of the module, details of which line threw the error and what cells/forms/dialogue boxes were selected/active at It is blank. @ whs... read review
I have one other Workbook where I have been able to include the Calendar and another one where I have this same problem. To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! So I see this: Set RngH = etc. Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts From what I have been able to gather, the 400 is a generic illegal operation code that could apply to just
Highlight the variables in your code, right-click, choose "add Watch...", click "OK", (Here's an excellent resource to help you with your debugging in general) and note the following: Which line hits In that case the RTE 400 is only a symptom. at the first beginning of the application it has shown a dialog box mention.. 'Excel could not find this Add-in installed. Just modify the existing IF statement to evaluate the sheetname as well.
All contents Copyright 1998-2016 by MrExcel Consulting. E-mail us or call us 302-584-1771, 8AM to 10PM U.S. Staff Online Now TerryNet Moderator DaveA Trusted Advisor Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts http://www.excelforum.com/showthread.php?t=575702 I've already done the add-in through Excel.
Any way thank you for clear explanation. Change the code of Userform1 to this: Private Sub CommandButton1_Click() UserForm2.Show vbModeless End Sub And run sub Main again. Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts From what I found the error 400 is part of Excel 97 (did not find this in the error code list The error message tells you to use this code:myForm.HidemyForm.Show vbModal2.7k ViewsView More AnswersRelated QuestionsHow do you use Visual Basic for Applications in Excel?Is there something like visual basic excel training in
You can break the relationship between the windows when you shown them non-modal, resp. I am really got vexed with this. If the worksheet is hidden you can either skip it completely like I've done in the code below or you can modify it to unhide the sheet first, process it, and Esker" mean?
Do you really think a developer would let some who didn't even know how to set a break point in VBE debug this macro? Any ideas now... I've tried to avert this by instead of deleting the row, changing that cell's color so I at least have SOMETHING to go by. Click the command button and the 2nd form is shown, move the window a little so that you can see the first form.
Now try to select a cell in the worksheet or the 1st form, it is possible! NSV Register To Reply 09-12-2006,08:05 AM #2 VBA Noob View Profile View Forum Posts Forum Contributor Join Date 04-25-2006 Location London, England MS-Off Ver xl03 & xl 07(Jan 09) Posts 11,988 Change the code in Userform2 to this: Private Sub CommandButton1_Click() UserForm1.Show vbModeless End Sub Run sub Main, the 1st form opens, click the command button the 2nd form opens. instead of Range("F24").Value use Cells(24,6).
The difference is that mine blows up when I do Workbook.RefreshAll Register To Reply 10-10-2013,11:58 AM #14 jasmith4 View Profile View Forum Posts Registered User Join Date 01-14-2011 Location N/A MS-Off share|improve this answer answered Jul 23 '12 at 18:16 JimmyPena 6,01932944 +1 Since this also works with the merged cells noted by the OP. –Gaffi Jul 23 '12 at If I close the application and restart it, again the same dialog box comes.
If you need lines of my code to know the answer, then I can assure you that you are in the dark as much as am I. 12-22-2009, 12:38 PM It turns out that I'd made a schoolboy error, looking for 'email' in the worksheet name when I should have been looking for 'Email'... In the example below the macro will be executed on all visible sheets in the workbook except for Sheet1 Code: Sub Clearcolors() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Register To Reply + Reply to Thread Page 1 of 2 1 2 Last Jump to page: « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There
View our list of code downloads. So whatever happens when you get the RTE 400 in your file, IMHO there are windows involved. Please don't suggest Formatting!! Click here to join today!
This sets the toolbars in the right order the second time. Thanks for your response. ...bob Bob Sutor Edited by ConstPM Saturday, January 04, 2014 9:23 PM Saturday, January 04, 2014 9:20 PM Reply | Quote 0 Sign in to vote Asadulla, The only way I can reproduce the error is to run a form.show command from the form itself which isn't a good way to do things.1.3k Views · View Upvotes ·