View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Craig[_21_] Craig[_21_] is offline
external usenet poster
 
Posts: 39
Default Hiding the CommandBars

Yes... the userform is the same file, I'll try creating another userform to
see if it does it too.
Craig

"Ron de Bruin" wrote in message
...
Hi Graig

Can't reproduce this
Is the userform in the same file ?




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


"Craig" wrote in message
news:5b19f.351926$oW2.340358@pd7tw1no...
I placed your code in ThisWorkBook.Activate and Deactivate
Works great from switching between worksheets.... but when I activate a
userform the gray blank bar comes back.
When I close the userform the blank gray bar is still there.

Craig



"Ron de Bruin" wrote in message
...
Hi Craig

Look here for example code
http://www.rondebruin.com/menuid.htm

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


"Craig" wrote in message
news:_r%8f.354301$1i.69552@pd7tw2no...
Hi there,
I'm trying to hide the look of excel in my program without creating
userforms for everything.
I'm usung this code at startup:

Application.CommandBars.ActiveMenuBar.Enabled = False
Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Enabled = False

This works but as I change sheets via command buttons... I get a blank
gray bar at the top of the screen.
It also does this when I bring up a Userform I created.

The only way I can get rid of this blank gray bar is by right clicking
and selecting one of the toolbars then right clicking again to remove
it.

Is there a way I don't have to see this blank gray bar??

Thanks Craig