I cannot enter information in excel sheet, info bounces to top

A

Ambitious Angela

I am entering information into an excel sheet and it bounces to the top of
the worksheet and overrites information. This sheet has alot of formulas in
it and some of the cells are locked. I checked to make sure they are not
locked and I tried the Turn automatic completion of cell entries off but that
also did not work
 
R

ryguy7272

Right-click the pesky worksheet tab, and click 'View Code'. Is there some
VBA code in the window that opens?
 
G

Gord Dibben

Please post some cell references instead of "into a sheet" and "bounces to
the top".

i.e.

I enter data in G23 and the data shows up in G1

Which cells are locked?

Do you have any event code in the worksheet module?


Gord Dibben MS Excel MVP

On Wed, 13 Jan 2010 07:33:02 -0800, Ambitious Angela <Ambitious
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Change cell color in protected sheet 1
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Allowing editing locked cells in a protected sheet in excel 1
Transfer info to new sheet by date 4
creating a sheet 1 of 3
Making an excel sheet so formulas can not be deleted in the sum to 2
protecting certain cells in Ecxel 2007 2

Top