Search results for query: *

There is no hidden windows available. When I try the Stop inside the code, the commandbars gets added correctly but is then removed by the other macro. The workbook or addin, or whatever it is, is not visible in the VBA editor list of VBAProjects, it is somehow opened after all other macros...

Hi combo, I think you are right, there is another addin that is visible in the VBA Editor but not in the Tools-->Addin list. This addin adds buttons to the commandbar add probably uses the reset preoperty. Is it possible to make my code run after this code? The last resort would be to try to...

Hi all of you willing to help. I have created a addin which on open should create some different commandbars. The worksheet menu bar gets added without any problem but the "Cell" ones do not. I don't get any errors and if I try to run the code after the workbook has been opened, the code works...

Thanx for your help guys, Selection.copy work just fine, I tried that before but´it must have been something else, because that time it did not work. Anythin with worksheet_selectionchange is not applicable because I´m putting the code in a Add-In (It could prob. work but it´s just to messy...

Hi everyone, I'm trying to create a macro that copies the cells that I currently have marked. Example: I select the cells C5:F13 (by marking them with the cursor) and the macro copies this range. If i after this selects G2:R15, the macro will copy this range.... I have searched for a solution...

Hi everyone, I'm trying to create a macro that copies the cells that I currently have marked. Example: I select the cells C5:F13 (by marking them with the cursor) and the macro copies this range. If i after this selects G2:R15, the macro will copy this range.... I have searched for a solution...

Hi everyone! I have created a userform on which I have a spreadsheet.The idea is that the user can paste specific data into this and then this data is exported into a open workbook in a predefined way. If I paste the data into a regular worksheet there is no problems but when pasting into the...

Hi everyone! I have created a userform on which I have a spreadsheet. The idea is that the user can paste specific data into this and then this data is exported into a open workbook in a predefined way. If I paste the data into a regular worksheet there is no problems but when pasting into...

Thank you Foada, I finally got it to work! Without yor help I would be stuck with this forever, finally I can put this behind me :D Hopefully I can help you in return sometime!

Ok let's see if I can explain better this time around! This is the function (Just something I put together to illustrate) Option Explicit Public c As New wsConstants Public Function membersnumber(member As Range, iRowTop As Integer) Dim ws As Worksheet Set ws =...

Hi Foada, It's a .cls

Hi, I have a VBA code that miss some class modules. I know what the class modules are supposed to do so I'm currently trying to rebuld them. My problem is the following. In Defenition Module Public c As New wsConstants In a seperate module I have the following code NumOfMembers =...