Controlling what is displayed and size of a workbook

**jonvanwyk** · 11-30-2010, 05:20 PM

Let us pretend for a moment that you have a form that one can fill out. This form ranges from A1 through O25. Is there any way to make it so when a user opens the excel document, it displays ONLY A1 through O25? That is to say that one would not see the toolbars, nor any whitespace outside of these cells. Even better, make it so a user would not even realize they were in an excel document if it weren't for the fact it was excel that opened it?

I have attached an edited screenshot to reflect the desired look.Thank you in advance for leading me in the right direction!

**TMS** · 11-30-2010, 06:05 PM

I suggest that you search this forum for "hiding ribbon". You should find several postings relating to this but, in particular, look for posts from Andy Pope.

Regards

**jonvanwyk** · 12-01-2010, 10:18 AM

Originally Posted by TMShucks

I suggest that you search this forum for "hiding ribbon". You should find several postings relating to this but, in particular, look for posts from Andy Pope.

Regards

Thank you for pointing me in the right direction

**jonvanwyk** · 12-01-2010, 11:15 AM

Originally Posted by TMShucks

I suggest that you search this forum for "hiding ribbon". You should find several postings relating to this but, in particular, look for posts from Andy Pope.

Regards

I have found a thread that should work, but it is not working.

Please Login or Register  to view this content.

I found the above code in the following thread:

http://www.excelforum.com/excel-2007...07-ribbon.html

Attached to this post is a screenshot of how I inserted this VBA code. I am still fairly new to VBA, so perhaps I performed the task incorrectly. Thank you in advance for any further help you are able to offer.