Forum Discussion
buttons go in hiding when I run macro
Subodh_Tiwari_sktneer thanks a million solved the purpose and will just try to understand it
1 more thing if I want to view the full sheet without running vba how do I do that because even if I press stop(break) it only shows what I had pressed last time the button
If you are talking about the layout in Attendance(2) sheet, all you need is to click the Apr button and the top month April will be displayed on the top.
In this approach, no rows or columns are being hidden but the desired month range comes on the top, that's it.
As far as your original approach is concerned you may insert a button with the following code underneath it to unhide all the columns...
Sub UnHideColumns()
ActiveSheet.UsedRange.Columns.Hidden = False
End Sub
If that takes care of your original question, please take a minute to accept the post with the solution provided as a Best Response to mark your question as Solved.