ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting rows on formula sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/222942-inserting-rows-formula-sheet.html)

broop[_11_]

Inserting rows on formula sheet?
 

I am working in Excel 2007 and I can't seem to enter rows on one
particular worksheet (formula worksheet). The only time I can enter a
row on this formula page is after my computer goes into sleep mode.
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 re-hide the worksheet I want
it
to take you back to a certain worksheet that I have not hidden how can
I
do this?

Broop


+-------------------------------------------------------------------+
|Filename: Test Master.zip |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=93|
+-------------------------------------------------------------------+

--
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=70944


Simon Lloyd[_112_]

Inserting rows on formula sheet?
 

broop;254051 Wrote:
I am working in Excel 2007 and I can't seem to enter rows on one
particular worksheet (formula worksheet). The only time I can enter a
row on this formula page is after my computer goes into sleep mode.
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 re-hide the worksheet I want it
to take you back to a certain worksheet that I have not hidden how can
I
do this?

BroopBroop can you also upload your 2007 version just in case the problem is

version specific?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70944


broop[_12_]

Inserting rows on formula sheet?
 

I can insert on all of the other worksheets it is just this one
worksheet within this workbook that i can insert rows or i have to wait
for my computer to go into sleep mode. Then i can insert a row but only
one.


--
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=70944


Simon Lloyd[_113_]

[SOLVED]: Inserting rows on formula sheet?
 

Glad we could be of help!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70944



All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com