Building an application on top of Excel

[Guest]

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

 

[Guest]

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.