Programming Buttons in Excel

[Jerminator]

Just getting started with VB and VBA. I do a lot of Workbooks monthly for my customers that I import a .csv and I try to have it automated as much as possible. What I would like to do is add buttons to my first worksheet and hide the remainder sheets. Which I have accomplished. The problem I am having is programming the buttons on click to open a particular hidden sheet in the workbook. Is this possible and does anyone know what the command for this would be? I would greatly appreciate it.

 

[elgringo56]

No corners necessary, Jak. I was trying to leat him to what you brought up any way. Have found that if someone takes the time to do that with me, I learn a bunches. Sorry if I sounded terse, but its late, and I am tired also. Have a good night

 

[Jerminator]

Thanks again. Like I said, the goal is to bring the hidden worksheet into a popup type window that can be closed out when done viewing. I appreciate the help on the Macro for programming the button to unhide the worksheet. I learned a lot in that procedure and will use that in the future for other applications, but as stated earlier, I would like to see the worksheet in a seperate window of some sort. I have been scanning my VB Programmers book for insight and haven't found anything yet.

 

[elgringo56]

I am sorry, jerminator but I am beyond thinking now. time to sleep. If you would care to take this up again tomorrow, I will be here to finish it. it is an interestine project to me... but for now, I must retire. I will check in tomorrow, or later today as it may be

 

[Jerminator]

No problem ElGringo. I will see if JAK can come up with something. If not I will definately be back on tomorrow to see if we can design such a monster. Thanks for all your help

 

[Jak]

Hi Jerminator

I have an example worksheet for you which I will forward to your e-mail address. When opened and Macros enabled you will find a button on sheet1. Click the button and a form appears. You have a few choices to unhide sheets or hide them all with the exception of Sheet1. I have kept it basic and hope this will help you out.