LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
BJ BJ is offline
external usenet poster
 
Posts: 51
Default Radio Button Printing Problems

Hi Ryan

Is there a 3D feature of these controls that I can turn off? I notice that
when I change the Special Effect to 'Flat' I get a dark outline around a
radio button and dark lines to the right and below on a checkbox.

"RyanH" wrote:

Have your friend send you their version of the Excel file. Then try to print
it.

Do you have to have the option button print? You could change the
properties of the option button to not print.

Where is this button located, Userform or Worksheet? Is it a Forms or
ActiveX Control? I'm just trying to recreate what you have so I can get a
clue here.
--
Cheers,
Ryan


"BJ" wrote:

Hi Ryan and thanks for the reply ...

I don't think it relates to the items you've described. I get it when I
print a doc but my cohort doesn't ... just hoping that maybe someone had seen
it before.

If you've got an email address I can send you a PDF of the print out to see
what you think.

I appreciate you taking the time to answer.

BJ

"RyanH" wrote:

Try going to the Properties Window of the radio button and change the
BackStyle Property to 0 - fmBackStyleTransparent

or

try changing the BackColor Property to another color if you wish.

I hope this helps! If so, let me know and click "YES" below.
--
Cheers,
Ryan


"BJ" wrote:

The 'Control' radio button - when printed - is surrounded by a dark
box ... ugly ... is there any way to change or remove this feature?

Thanks.

 
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
radio button Chey Excel Discussion (Misc queries) 1 January 3rd 08 07:42 PM
"RADIO BUTTON" Ian Shere Excel Discussion (Misc queries) 1 July 4th 05 10:59 PM
How do I lock a radio button group if a N/A button is selected worry a lot Excel Discussion (Misc queries) 2 May 21st 05 08:33 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM
Command Button problems when printing Don't know enough Excel Programming 1 April 17th 04 03:38 AM


All times are GMT +1. The time now is 07:44 AM.

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"