I am working in Excel 2007 and i can't seem to enter rows on one
particular worksheet When my computer goes into sleep mode and i come
back and try to insert a row i can however i can't keep inserting
rows???? I have to wait for it to go back into sleep mode and then i can
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 to
keep at the bottom of my workbook. On each worksheet there are buttons
once you click on the button it will open a worksheet that i have
hidden. Once you click on the button to rehide the worksheet i want it
to take you back to a certain worksheet that i have not hidden how can i
do this. I am working with the Code Cage now for some reason i can't
upload the docment so that it would be easier for someone to understand
what i am trying to accomplish.


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70927

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


"broop" wrote:


I am working in Excel 2007 and i can't seem to enter rows on one
particular worksheet When my computer goes into sleep mode and i come
back and try to insert a row i can however i can't keep inserting
rows???? I have to wait for it to go back into sleep mode and then i can
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 to
keep at the bottom of my workbook. On each worksheet there are buttons
once you click on the button it will open a worksheet that i have
hidden. Once you click on the button to rehide the worksheet i want it
to take you back to a certain worksheet that i have not hidden how can i
do this. I am working with the Code Cage now for some reason i can't
upload the docment so that it would be easier for someone to understand
what i am trying to accomplish.


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70927