Posts by mzimba

Re: Application Events

Quote from rory;775506

There is an issue with a recent security update for Office. You need to locate the add-in file in Explorer, right-click it, choose Properties, then check the box to 'Unblock this file' and press Apply.

Rory- did that fix the issue for you? Can you open the add-in without an issue and are you using 2013 or newer excel version?

I don't have the option to unblock the add-in in properties. It looks like mine was unblocked.

Re: Application Events

Quote from cytop;775494

Can load this in Excel 2010 no errors, no problems - but strangely enough it simply will not automatically load in 2013/2016. There's no error, but define the add-in, it displays the menu. Close Excel and restart, no add-in.

Something to look at, but which version are you using?

Also, It's a little pointless asking someone to have a look at code in a file and then uploading a file with the project password protected... others may have had a problem with that.

Sorry forgot to include the password. It's encompass.

Im using excel 2013.

Re: Application Events

Quote from cytop;775352

Excel is an event driven application. Everything happens in response to an event and events are scoped to the Application, a Workbook or a Worksheet. For example:
Workbook_Open is fired when a particular workbook is opened.
Workbook_Change is fired when any worksheet in a workbook is changed
Worksheet_Change is fired when the worksheet containing the code is changed.

Your comment that "It just gets stuck" does not really explain anything.

Is the addin even loading? If it is, does it error? Not do as you expect??

You must use the Options/Addins menu to set an addin to load automatically when Excel starts. Have you?

Basically your question is impossible to answer with the information you have given. Upload a copy of the addin.

[sw]*[/sw]

You may not be able to upload an XLAM file due to restrictions on the forum, just add a .TXT extension and it will upload.

Display More

Cytop- thank you so much for the response.

Please see the add-in attached. The file was initially too big but i had to take out some of the code to make it smaller.

To answer you question:
Is the addin even loading? If it is, does it error? - yes it does load. If i try to open excel application for the first time it gets stuck trying to open the add-in but if i open another non excel file it will open and once open the add-in works without a problem. The issue is just when you try to open the excel when the add-in is installed. If the add-in is uninstalled excel opens without a problem.

ou must use the Options/Addins menu to set an addin to load automatically when Excel starts. Have you? - i havent done this, i cant figure out how to do it.

Thank you again.

Re: Application Events

Quote from cytop;775349

That does not make sense... How can an Add-in be active when Excel is closed?

Sorry maybe I should be a little more clear. I created an add-in and for some reason when i shut down and try open the excel application the application doesn't open. It just gets stuck. I was thinking about this issue and thought maybe if I disabled the add-in when the application shuts down and reenable after the application opens again that might be the solution I need.

From what I was reading it sounds like an application event might be what I need to get around the issue. I'm very open to any suggestion that you might have.

This is also posted here: http://www.mrexcel.com/forum/e…not-open.html#post4599448

Thanks.

Hi all,

Can someone please help me understand what application events do.

I'm trying to create a code that will disable an add-in when the whole excel application is closed completely and then enable that same add-in when the application is opened or restarted.

Any help will be very much appreciated.

Thank you in advance.

Mjoza

Re: Loop Through Sheets

Thanks you Pike

I'm having an issue with the following code can you please take a look. The code is supposed to loop through sheets that are not "Total" or "Balance" and copy and paste values a column over. Sheet 100001 is used to find what the last row is (its the same for all the sheets that are going to be looped through).

I just cant seem to figure out how loops work.

Thank you in advance.

Sub RollForward()


Dim lrow        As String
Dim sht         As Worksheet
Dim func        As String
Dim ibx         As String
Dim wsb          As Worksheet




Set sht = ThisWorkbook.Worksheets.Sheets("100001")
lrow = sht.Cells(sht.Rows.Count, "B").End(xlUp).Row




For Each wsb In Worksheets
        If (wsb.Name <> "Totals") And (wsb.Name <> "Balance") Then
             wsb.Range(Cells(lrow, 5), Cells(lrow, 5).End(xlUp).Offset(1, 4)).Copy Destination:=swb.Cells(11, 6) 'its breaking here and its supposed to paste values
        End If
Next wsb




ibx = InputBox("Enter the Report Month", "Report Month", "Mmm-YY")




Sheets("Totals").Select
    Range("b2").Value = ibx




End Sub

Re: VBA Copy and Paste Errors

Thank you so much!

Re: VBA Copy and Paste Errors

The values in cell from C2 should be overwriting B2 in the balances sheets and I would expect B2 to have something when the code runs but it doesnt. The values being copied should go to B2 in balances tab one at a time. My problem is that the B2 is blank.
Thanks for looking

I have the following code which is supposed to loop through sheets and copy and paste but for some reason I cant paste values in the Balances tab. I see the values being pasted as the code is running and it looks like they are being deleted right away. I dont get any errors

Thanks in advance.

Sub test()


Dim ws     As Worksheet




        For Each ws In Worksheets
            If (ws.Name <> "Totals") And (ws.Name <> "Balances") Then
                    ws.Range("c2").Copy




                With Sheets("Balances")
                    .Range("b2").PasteSpecial Paste:=xlPasteValues
                    'some other code will go here
                End With
            End If
        Next ws
End Sub