Sikorsky27
New Member
- Joined
- Jun 24, 2021
- Messages
- 40
- Office Version
- 2016
- Platform
- Windows
Okay, I have a script to send me to another sheet and then highlight its importance. But I am looking to add to it for when it goes to said sheet, it will create a back button to go back to the original sheet and deletes the button once used (last part is if at all possible since this will be reused on a total of 48 different but similar buttons). The button should fill whole space on "Assessment" J1. This is the current script
Sub One()
ThisWorkbook.Sheets("Assessment").Visible = True
ThisWorkbook.Sheets("Assessment").Activate
ActiveSheet.Range("A2:I2").Select
ThisWorkbook.Sheets("Q1").Visible = False
End Sub
So after it makes a button and I need to go "back". It should rehide "Assessment", unhide "Q1" and get rid of the button it just placed on the "Assessment" since I have 48 questions and I need the button to be able to go back to each respected question "Q1", "Q2" etc... Thank you!! Just write it if possible, for above script and I will add it to the others.
Sub One()
ThisWorkbook.Sheets("Assessment").Visible = True
ThisWorkbook.Sheets("Assessment").Activate
ActiveSheet.Range("A2:I2").Select
ThisWorkbook.Sheets("Q1").Visible = False
End Sub
So after it makes a button and I need to go "back". It should rehide "Assessment", unhide "Q1" and get rid of the button it just placed on the "Assessment" since I have 48 questions and I need the button to be able to go back to each respected question "Q1", "Q2" etc... Thank you!! Just write it if possible, for above script and I will add it to the others.