LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default I don't want to display any controls in excel.

Amar,

This will hd all commandbars on opening and restore on close

Option Explicit

Private mFormulaBar

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB

Application.DisplayFormulaBar = mFormulaBar
End Sub

Private Sub Workbook_Open()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next oCB

mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--

HTH

RP
(remove nothere from the email address if mailing direct)


"areddy" wrote in
message ...

Hello All,

I want to do some customization in excel.when I open new or existing
excel I don't want to display any menu bars, tool bars or no other
controls.
Just I want to display plain excel file with one button like showing in
the attachment.
If I click on button I want to open 'save as' window to save the file.

Except that I don't want to display any controls in the excel sheet...

Please see the attachment.

Thanks & Regards,
Amar...


+-------------------------------------------------------------------+
|Filename: display only button in excel..doc |
|Download: http://www.excelforum.com/attachment.php?postid=3969 |
+-------------------------------------------------------------------+

--
areddy
------------------------------------------------------------------------
areddy's Profile:

http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=480523



 
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
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
I don't want to display any controls in excel. areddy Excel Discussion (Misc queries) 0 October 31st 05 08:46 AM
Event procedures for controls added with Controls.Add John Austin[_4_] Excel Programming 1 March 9th 05 03:31 PM
Help on Excel controls Reney Langlois Excel Discussion (Misc queries) 1 March 9th 05 02:48 PM
ActiveX Controls Display Issue? [email protected] Excel Discussion (Misc queries) 0 March 5th 05 05:43 PM


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