Hi Guys,
I want to tab thru my protected sheet and have carried out all the necessary
locking and unlocking of cells etc. However, when tabbing between certain
cells, the tab function appears to malfunction as it flicks between one cell
and another a few times before moving on to the rest of the cells. Any
ideas? The cells in question are merged. Don't know if this helps

I've never seen this.

Any chance that you have a worksheet_selectionchange event firing?

If no, you may want to share the version of excel you're running. Maybe someone
can test.

Stumped wrote:

Hi Guys,
I want to tab thru my protected sheet and have carried out all the necessary
locking and unlocking of cells etc. However, when tabbing between certain
cells, the tab function appears to malfunction as it flicks between one cell
and another a few times before moving on to the rest of the cells. Any
ideas? The cells in question are merged. Don't know if this helps

--

Dave Peterson

Hi Dave

Never heard of a 'worksheet_selectionchange event firing'. Can you explain
further please?

"Dave Peterson" wrote:

I've never seen this.

Any chance that you have a worksheet_selectionchange event firing?

If no, you may want to share the version of excel you're running. Maybe someone
can test.

Stumped wrote:

Hi Guys,
I want to tab thru my protected sheet and have carried out all the necessary
locking and unlocking of cells etc. However, when tabbing between certain
cells, the tab function appears to malfunction as it flicks between one cell
and another a few times before moving on to the rest of the cells. Any
ideas? The cells in question are merged. Don't know if this helps

--

Dave Peterson

Excel has a bunch of built in events that just lurk in the background waiting
for you to do something--activate a sheet, activate a workbook, change a cell,
select a cell, ... lots of them.

Some are at the workbook level, some are at the worksheet level (and some can be
at the application level).

Developers can tie into these events and have excel do stuff that looks like
magic.

If you rightclick on the worksheet tab that's having the trouble and select view
code, you may find something in that window that's causing your trouble.


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

And you can read about application events on Chip's site:
http://www.cpearson.com/excel/AppEvent.htm


Stumped wrote:

Hi Dave

Never heard of a 'worksheet_selectionchange event firing'. Can you explain
further please?

"Dave Peterson" wrote:

I've never seen this.

Any chance that you have a worksheet_selectionchange event firing?

If no, you may want to share the version of excel you're running. Maybe someone
can test.

Stumped wrote:

Hi Guys,
I want to tab thru my protected sheet and have carried out all the necessary
locking and unlocking of cells etc. However, when tabbing between certain
cells, the tab function appears to malfunction as it flicks between one cell
and another a few times before moving on to the rest of the cells. Any
ideas? The cells in question are merged. Don't know if this helps

--

Dave Peterson


--

Dave Peterson