Buttons/inserting rows

[broop]

I am working in Excel 2007 and i can't seem to enter rows on on
particular worksheet When my computer goes into sleep mode and i com
back and try to insert a row i can however i can't keep insertin
rows???? I have to wait for it to go back into sleep mode and then i ca
only insert one row and i have to start the process all over again.

The other question i have is i have two worksheet tabs that i want t
keep at the bottom of my workbook. On each worksheet there are button
once you click on the button it will open a worksheet that i hav
hidden. Once you click on the button to rehide the worksheet i want i
to take you back to a certain worksheet that i have not hidden how can
do this. I am working with the Code Cage now for some reason i can'
upload the docment so that it would be easier for someone to understan
what i am trying to accomplish

 

[Scotty9349]

If I understand your second question, then this is what I have used:

Sheets("Unhidden").Select
Range("A1").Select

Put this right before the Exit Sub line and all should be good.

scotty