Activate a specific sheet when opening a workbook.

[Aland2929]

I am using the following code to activate a sheet named "Profit" but receive an error message when opening the workbook? The spelling is correct and there is a sheet named "Profit"?

Sub GoToProfit()
    Application.ScreenUpdating = False
    Unload UserForm2
    Sheets("Profit").Activate
    Range("A1").Offset(1, 2).Select
End Sub

Thanks in advance

[LaffyAffy13]

What does the error message say? Is your userform still named "Userform2"?

[Aland2929]

Error message: "Application-defined or object-defined error" - It then highlights the code line:

Sheets("Profit").Activate

[tigeravatar]

It won't be able to activate the sheet if it is hidden. Also, sometimes sheet names can have leading or trailing spaces causing the error, for example it could be "Profit " or " Profit", etc. You'll want to make absolutely certain the sheet's name is correct. If the sheet is hidden, you'll need to unhide it before you can activate it.

[LaffyAffy13]

What tiger said. If you still get the error, then I'm lost.

[Aland2929]

Thanks for your reply, but I did check the spelling and there are no issues there? I have just opened the file and don't get an error message and everything is working? This has happened before with other files so it seems to be intermittent? I have not changed anything so am really confused.

[LaffyAffy13]

Maybe the sheet was hidden the last time the file was saved? and now it's not?

[Aland2929]

No definitely not.

[LaffyAffy13]

Weird. I created my own version of your above sub and had no issues when opening the workbook it was in. So idk. Glad it randomly fixed itself though

[Aland2929]

The same problem has re-occurred this morning after I closed & re-opened the workbook? I did this often yesterday without any issues though? If I right-click the "Arrow button" the macro is assigned to, and then click on the drop-down list for "Macros In", It shows the following: 1. All Open Workbooks. 2. This Workbook. 3. ABC Costing Project.xlsm. I only have 1 workbook open which is ABC Costing Project.xlsm. Why does it show 2 AND 3 if "This Workbook" is ABC Costing Project.xlsm?

[Aland2929]

When I open Excel and Press [Alt] [F11], there are two projects named FUNCRES.XLAM and ATPVBAEN.XLAM in addition to VBAPROJECTS (Book1). I don't know where these projects (XLAM) come from? Could these projects be causing an intermittent problem and how do I delete them? When I click on ATPVBAEN.XLAM, it prompts for a password?
Thanks in advance.

[Aland2929]

I found these under "Add Ins" and removed them but could they have caused a problem with the ribbon display when I had them open?

[tigeravatar]

.xla and .xlam files are add-ins. They are VBA code that have been saved in that format and then added to your Excel in order to expand its functionality with custom code. They do not require that you enable macros in order for them to work. As such, it's possible that either one of them had a workbook_event routine that could have been triggered when you opened, closed, saved, or performed any other event that was causing problems. You'll only know for sure if the issues doen't happen again now that you have removed those add-ins.