Hide ribbon and toolbar

Hello all,
Yes, I'm new to this forum. I have to say, the info here is great and has gotten me over a few difficult moments. Now I have another hurdle I just can't overcome.

I am using the following code to hide the workbook ribbon and toobar so the end user only sees the worksheet and data entry fields. However, once the code is in place and working, I'm even blocked from breaking through and getting back to the development stage. Access has a Shift + open file override. Does Excel have something similar? Or saving two copies, one with the code and one without, my only option??

Thanks in advance!
Nathalie

Please Login or Register  to view this content.

See post from yesterday....

http://www.excelforum.com/excel-prog...html?p=3286593

Same issue?>

Well, hot dog. This is perfect. Thanks! I did try searching for posts that previously addressed this topic. I never would have thought that the thread title "Double Click Excel Window Title Bar Duirng Full Screen Mode" answered my question.

Nathalie

Thank you. So I do have options. I like that.
Nathalie

So, today I've run into an interesting problem. I have successfully and delightfully employed the suggested solution to hide the ribbon and toolbar when the program opens and the "get me out of this" macro does exactly that. Of course, I tested this on my Mac mini with Excel:Mac 2011. The file opens but I get a "Could not load an object because it is not available on this machine" error message. So, the ribbon still appears. The debugger highlights the Application.Toolbars("Ribbon").Visible part of the macro. I'm guessing that's the object referred to in the error message. Am I correct? And how do I get that object available on this machine?

Nathalie

Please Login or Register  to view this content.