If there's anything unclear, please feel free to let me know. I've create a sample project which is an Excel workbook project, you can download it from the below link:
If my assumption is not suitable to your scenario, please correct me and I'll figure out the solution for you.Īdapt the last line of code to below = Private void Dobutton1_Click(object sender, EventArgs e) I'm not sure why you have the code below. private void button1_Click(object sender, EventArgs e) When you drag a button control to your workbook and double click on the button, Visual Studio will generate a button click event handler seen as below.
Suppose the only unhidden sheet is Sheets and you have your command button on it, then here comes the 2nd question. So, could you please tell me which sheet is the unhidden worksheet of your workbook? I guess the command button is on the "only unhidden worksheet" thus I think the code snippet used to hide Sheets is not supposed to be in public class Sheet4. įrom this line code I've realized that you want to hide the Sheets of your workbook and you've mentioned that "I want to unhide a hidden worksheet from a button on the only unhidden worksheet To begin with, you have the public class Sheet4Īnd Sheets ). The only problem of you code is syntax error. Which kind of project are you working with? Are you working on a document-level customization or an application level add-in?īased on my observation that your code is like an Excel workbook project.
0 kommentar(er)
