Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would think not if you want to use the worksheet grid. You can hide sheet
tabs and menus, however. for i = 1 to Application.CommandBars.count if i < 3 then Application.CommandBars(i).Enabled = False else Application.CommandBars(i).visible = False end if next You would need to record which commandbars are changed so you can restore them. sheet tabs are in the view tab under Tools=Options. You can get the code with the macro recorder. -- Regards, Tom Ogilvy "MSA" wrote: I have built a work book as an application (with macros for navigating etc.). Now I would like to get rid of the Excel shell thatis to say suppress the work sheet tabs and the menus and use autoexe the same way as in Access you can do, is this possible? Thanks for your input in advance. Regards, MSA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Building an Application | Excel Discussion (Misc queries) | |||
Excel document building | Excel Discussion (Misc queries) | |||
When building formula in excel, it would be very useful to have t. | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
VBA building stand alone application | Excel Programming |