LinkBack URL
About LinkBacks
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"?
Thanks in advance
Please Login or Register to view this content.
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"?
Thanks in advancePlease Login or Register to view this content.
What does the error message say? Is your userform still named "Userform2"?
~~LaffyAffy13~~
If I have helped you solve your problem, please be sure to clickat the bottom left of my post.
Thanks.
Error message: "Application-defined or object-defined error" - It then highlights the code line:Please Login or Register to view this content.
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.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
What tiger said. If you still get the error, then I'm lost.
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.
Maybe the sheet was hidden the last time the file was saved? and now it's not?
No definitely not.
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
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?
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.
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?
.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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks