sassriverrat
Well-known Member
- Joined
- Oct 4, 2018
- Messages
- 655
Hello
So I have a macro that adds a sheet, formats it, adds the formula, and adds buttons (calling other macros). There are 7 buttons made for each sheet made- so I'd like to know how to hide two of the buttons when the sheet is first made (I presume for the button itself, when it's made I just specify it as visible = False) but it seems the buttons aren't always numbered the same on each sheet made- I'd like one of the other buttons to be used to unhide the two hidden buttons, if that makes sense. Not sure how to unhide the buttons if the numbers are always changing (like button19 for a hidden button on one page might be button 7 on the next page).
Thanks!
So I have a macro that adds a sheet, formats it, adds the formula, and adds buttons (calling other macros). There are 7 buttons made for each sheet made- so I'd like to know how to hide two of the buttons when the sheet is first made (I presume for the button itself, when it's made I just specify it as visible = False) but it seems the buttons aren't always numbered the same on each sheet made- I'd like one of the other buttons to be used to unhide the two hidden buttons, if that makes sense. Not sure how to unhide the buttons if the numbers are always changing (like button19 for a hidden button on one page might be button 7 on the next page).
Thanks!