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

I have placed a Calendar Control on my spreadsheet. I need to be able to
access a menu item and hide the calendar, or show it if it is hidden. I
cannot find the code for hiding the control.

Thanks in advance
--
Robert Hill

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 276
Default Calendar Control

will application.displayalerts=false
do it?

"Robert" wrote in message
...
I have placed a Calendar Control on my spreadsheet. I need to be able to
access a menu item and hide the calendar, or show it if it is hidden. I
cannot find the code for hiding the control.

Thanks in advance
--
Robert Hill



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Calendar Control

See
http://www.rondebruin.nl/calendar.htm

You can use
Calendar1.Visible = True

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Robert" wrote in message ...
I have placed a Calendar Control on my spreadsheet. I need to be able to
access a menu item and hide the calendar, or show it if it is hidden. I
cannot find the code for hiding the control.

Thanks in advance
--
Robert Hill

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
Calendar Control Benz Excel Programming 5 October 15th 08 01:26 PM
Calendar Control Benz Excel Programming 6 July 24th 06 04:42 PM
Control disappeared problem - specifically, the Calendar Control JMMach[_2_] Excel Programming 0 December 16th 05 01:53 AM
Calendar Control monagan[_2_] Excel Programming 0 August 5th 04 05:47 PM
Calendar Control: Can't exit design mode because control can't be created Rone Excel Programming 0 May 24th 04 04:01 PM


All times are GMT +1. The time now is 12:30 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"