Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kim
 
Posts: n/a
Default Columns in Excel will not allow user to click in them

I have a spreadsheet with several columns of information. Two of those
columns will not allow the user to activate any of its cells. When the user
attempts to click on a cell in one of the two columns, the spreadsheets jumps
to a different location and randomly activates a different cell. I also
cannot isolate selection the entire column by clicking on the column letter
at the top. I can however, use ctrl+click to select the two problem columns
(I must begin with an active cell outside of the problem columns). Any
suggestions as to what is causing this behavior?

FYI: I can copy the entire worksheet and paste the information into a
different spreadsheet and the problem columns work properly.

Thank you for your feedback.
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

The worksheet is protected. To learn more, check out:

http://j-walk.com/ss/excel/usertips/tip022.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a spreadsheet with several columns of

information. Two of those
columns will not allow the user to activate any of its

cells. When the user
attempts to click on a cell in one of the two columns,

the spreadsheets jumps
to a different location and randomly activates a

different cell. I also
cannot isolate selection the entire column by clicking

on the column letter
at the top. I can however, use ctrl+click to select the

two problem columns
(I must begin with an active cell outside of the problem

columns). Any
suggestions as to what is causing this behavior?

FYI: I can copy the entire worksheet and paste the

information into a
different spreadsheet and the problem columns work

properly.

Thank you for your feedback.
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 03:19 PM
How can I see column headings of hidden columns in Excel before u. Beachcomber Excel Discussion (Misc queries) 10 December 10th 04 02:35 PM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 03:32 AM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 11:12 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"