Disappearing controls! 
Author Message
 Disappearing controls!

I have a sheet filled with charts and a button on the sheet to set the
printer (to adobe acrobat) and then print preview the area of the sheet
containing the charts.

This works beautifullt but when I close the print preview, all the button
controls on the sheet (not the shapes) exceot for the button I pressed to
print preview have disappeared. They return when I select a call but as the
sheet is protected to work around it I'll need to unprotect it select a cell
and then protect it again which seems like unecessary programming overhead
if it can be fixed simply in some other way.

Anyone know what may be going on? Help much appreciated.

Kind rgds, Mark



Thu, 08 Jul 2004 04:55:18 GMT  
 Disappearing controls!

Quote:

> when I close the print preview, all the button
> controls on the sheet (not the shapes) exceot for the button I pressed to
> print preview have disappeared

Odd.
Are they buttons from the Control Toolbox or from the Forms Toolbar?
Are they set to print or not?
Do you get the same behaviour with a different printer driver?
Do you have a Workbook_BeforePrint macro?  If so, what does it do?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup



Mon, 12 Jul 2004 08:44:20 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Disappearing Controls

2. disappearing controls

3. disappearing control tips

4. Disappearing controls and subforms!!

5. Disappearing Control

6. Disappearing controls on form...

7. Disappearing Controls

8. Help with disappearing control source ?

9. HELP Disappearing CONTROL PANEL icons

10. Custom Controls Disappear - Help Please


 
Powered by phpBB® Forum Software © phpBB Group