Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default MultiPage tab


Is there a way to programatically stop the TAB from going to the
MultiPage tab at the top of a multipage control? I'd like to be able
to click it with the mouse but not be a tab stop when the TAB key is
used.


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=533629

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default MultiPage tab

MultiPage1.TabStop = False

But this is a property which you can also manually define in the properties
window.

Regards,
Edwin Tam

http://www.vonixx.com


"JWM6" wrote:


Is there a way to programatically stop the TAB from going to the
MultiPage tab at the top of a multipage control? I'd like to be able
to click it with the mouse but not be a tab stop when the TAB key is
used.


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=533629


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default MultiPage tab


I understand that there is the "TabStop = T/F" property for the object
on the page. But the Page object itself only has an "Index" property
no TabStop property, starting at 0 for the left most and incrementin
across the different pages.

Doesn't seem that I can (at the moment) keep the page from being a ta
stop

--
JWM
-----------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...fo&userid=3341
View this thread: http://www.excelforum.com/showthread.php?threadid=53362

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default MultiPage tab

You selected only a tab of the multipage control. You need a bit of skill to
select the entire multipage control.

You can try this:
- Click once on the area of the multipage control
- click once carefully on the edge of the multipage control

Then, you should have the actual multipage control selected, and you should
see the Tabstop property in the properties window.

Regards,
Edwin Tam

http://www.vonixx.com

"JWM6" wrote:


I understand that there is the "TabStop = T/F" property for the objects
on the page. But the Page object itself only has an "Index" property -
no TabStop property, starting at 0 for the left most and incrementing
across the different pages.

Doesn't seem that I can (at the moment) keep the page from being a tab
stop.


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=533629


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default MultiPage tab


Will try - Thanks!


--
JWM6
------------------------------------------------------------------------
JWM6's Profile: http://www.excelforum.com/member.php...o&userid=33413
View this thread: http://www.excelforum.com/showthread...hreadid=533629



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
MultiPage tab? capt Excel Discussion (Misc queries) 2 January 28th 08 08:01 PM
vba - using multipage ajliaks[_23_] Excel Programming 3 August 9th 04 01:29 PM
Multipage Aksel Børve Excel Programming 1 March 1st 04 08:52 AM
MultiPage Michael[_25_] Excel Programming 3 January 6th 04 12:49 PM
Multipage Paul Excel Programming 1 July 9th 03 02:34 PM


All times are GMT +1. The time now is 04:54 PM.

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

About Us

"It's about Microsoft Excel"