Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi
Is there a way to quickly disable all NONE active tabs on a multipage, with out having to reference each page?
Example
I have Multipage1 which will not have its tabs visible and pages will change via buttons. On each page of MultiPage1 I will have Multipage2 this will also have several pages. A bit like the image below. All pages must be enabled at the start.
On EACH PAGE of Multipage2 there will be buttons TO RUN THE CODE.
What I am after is that when the buttons is clicked and code runs, it will disable all other pages in this case it will be Page5 and 6. When the code ends it will enable the disabled pages. Some thing like this Mr Excel Links which was for a tab strip.
Is there a way to quickly disable all NONE active tabs on a multipage, with out having to reference each page?
Example
I have Multipage1 which will not have its tabs visible and pages will change via buttons. On each page of MultiPage1 I will have Multipage2 this will also have several pages. A bit like the image below. All pages must be enabled at the start.
On EACH PAGE of Multipage2 there will be buttons TO RUN THE CODE.
What I am after is that when the buttons is clicked and code runs, it will disable all other pages in this case it will be Page5 and 6. When the code ends it will enable the disabled pages. Some thing like this Mr Excel Links which was for a tab strip.
VBA Code:
Private Sub CommandButton1_Click ()
' Command Button 1 is on Page 4, On click All NONE active pages on MultiPage2 are disabled.
'My Code runs
'My Code Ends and then
'Code to enable all disabled pages on multipage 2
End Sub