View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default VBA code to locate the command bar number the printer button is on

Hi Mike,

The 2nd answer would not show anything. However, I do need the printer
command button's visible command bar number. Any ideas how to correct
the 2nd answer.


Testing, the second macro returned the following message:

Commandbar: Standard position: 5


---
Regards,
Norman



"mikeburg" wrote in
message ...

Thanks a lot.

The 1st answer gave all command bars.

The 2nd answer would not show anything. However, I do need the printer
command button's visible command bar number. Any ideas how to correct
the 2nd answer.

By the way, I am using Excel XP (version 2002, I think).

Thanks a million, mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=507006