Created a macro that will unhide 10 worksheet tabs based on a range reference. Macro works successfully in opening all 10 worksheets when run via macro window. But when I assign the macro to a command button the macro stops after two iterations in the middle of the process. If I click the button again it will only execute 2 iterations at a time on each button click. Below is a screenshot of macro. Using excel 365.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Command Button Macro not fully running
- Thread starter GeoM
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,286
- Office Version
- 365
- Platform
- Windows
- Mobile
Please please please paste your code into your post instead of showing a picture of it. If I am going to reproduce your problem I have to type all this in from scratch.
What module contains this code?
What worksheet contains the button?
Do not rely on what sheet is active. Be explicit:
I am not sure that is causing your problem, hard to tell if I do not have your file for testing. But I suggest giving it a try.
What module contains this code?
What worksheet contains the button?
Do not rely on what sheet is active. Be explicit:
VBA Code:
With Worksheets("notes")
While .Cells(iNum1, 12).Value <> ""
Worksheets(.Cells(iNum1, 12).Value).Visible = True
iNum1 = iNum1 + 1
Loop
End WithI am not sure that is causing your problem, hard to tell if I do not have your file for testing. But I suggest giving it a try.
Upvote
0
