How do I make my Excel-document automatically display in full screen-mode when it is loaded?
How do I make my Excel-document automatically display in full screen-mode when it is loaded?
May be this link will help?
http://www.bettersolutions.com/excel...U822216331.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
If you use an auto open macro with the followingthen excel will open in full screen mode.Please Login or Register to view this content.
A question I would like to ask anyone is if it is possible to disable the return to normal mode by the user ?
Thanks
Jeff
Sounds good. How do I create an "auto open macro"?Originally Posted by solnajeff
If you see the code from the last post that is all you need, just paste it into a module and it will execute when you open the worksheet.
Regards
Jeff
This is probably an ignorant question but I'm not very experienced with excel:Originally Posted by solnajeff
What is a module?
Dear Sir , follow those stepsOriginally Posted by white-k
1- open the excel sheet
2-from the menu par open Tools >Macro >Security
and chose the LOW choice .
then
press
alt+F11 (both together)
in this screen
from the menu bar chosse Insert > Module
in the right side there is an empty area Paste the code in it
then close and save and reopen and u will see the chage
Plz , u can read those steps from the first LINK the that OLD sent to u it's realy great
good luck and many thanks to OLD
Excellent instructions Nasser and good help from all you guys!
Works like a charm now!
Thanks! :oD
Last edited by white-k; 06-18-2007 at 01:43 PM.
By the way...while we are at it...
Is there also a way to, at the opening of this document, get rid of the following:
1. "Row & column headers"
2. "Worksheet Menu Bar"
As you can see, I want the whole screen to be covered by the very document only, when it loads. (In other words, no visible menus or anything).
You guys got good advice on this as well?
1. You can use this code in the same macro you used for the above request:
2. Sorry, not sure how to get rid of the menu bar.Please Login or Register to view this content.
Jason
Originally Posted by jasoncw
Thanks Jason!
I'll investigate further on how to remove the menu-bar.
Please Login or Register to view this content.
Did you get this to work?
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
The macro works fine but I cant get it to run automatically when i open the file.
is there anyway to do it?
thanks for the help!
Use this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Still didnt work....
still didnt work....
Hello New here 1st post,
want to do the same thing for only 1 excel program i have.
I want to email this to some other and have it open the same full screen I can do this on my PC exit it on full screen it will reopen full screen.
I run all the Macors here and none do any thing to force a full screen open in any other computer I email to .
Is there any help for this?
Thanks
B
Aero Man,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks