Recent content by Helnora

I replaced the xlNone, xlAutomatic etc with the values on the link below, this solved my problem. https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.constants.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1

For the “Union” I get error when compiling. r1.Interior.ColorIndex gives error when running the code. It just says there something wrong in the line when evaluating. xlNone xlAutomatic seems to be a problem. "With … End With " is also not possible in the VBA compiler...

Dim ws As Worksheet Set ws = Application.Worksheets(“test”) Set r1 = ws.Range( ws.Cells(9, 2), ws.Cells(EndRow, 20)) Set r2 = ws.Range( ws.Cells(9, 22), ws.Cells(EndRow, 26)) 'Set r3 = Union(r1, r2) - this do not work…? r1.Interior.ColorIndex = xlNone - this is not possible??

Without “Application” then compiler says “unknown method or routine: ‘tesetSheetName’”.

I really do not know what is wrong. This is the line: sheettest = Application.testSheetName(WName) testSheetName is another function that is also in the VBA compiler.

In the VBA compiler I call another function also inside the VBA compiler. I do not get errors when compiling. I get the following error, but do not understand what is wrong.

yes, but maybe not the optimal solution.

This is only way I could find to refocus the excel window. This works, but Excel file withou XlsPadlock do not need this. Sub Workbook_Open() LoadCustomRibbon UserForm.Show End Sub Sub UserForm_Activate() Me.Hide End Sub

Any method to make the ribbon load at once? Without clicking another window and returning to excel?

Thank you!!!

I compiled one xlsm file to .exe file. Moved the .exe file to another folder and renamed it. I compiled the xlsm file again, and moved and renamed this file to another folder again. When I make changes to the sheets in the first .exe file, the changes are also made to the sheets in the second...

I still get the problem. Started a new test project. With “do not disable access to XLStart user folder" ON - I get ribbon made by VBA, and 2 other windows opens, and I have to terminate the application with the Task Manager. With “do not disable access to XLStart user folder" OFF - I do not...

Today, after deleting and reinstalling XLS Padlock, I have the problem again. Maybe it is my VBA code, but I have not idea what causes this problem. Problem solved. If Advanced options -> “do not disable access to XLStart user folder" is checked the problem occurs.

This problem is solved. I had version 3 installed. With version 2017.0.1 everything was good:grinning:.

My macro adds the ribbon into the file \Users\User\AppData\Local\Microsoft\Office\Excel.officeUI as explained in the link here: https://stackoverflow.com/users/1582419/roi-kyi-bryant