Screen Size

[Lyncz92]

Hey guys,

I got a question. when i do a google search for dashboard idea's i got alot of nice idea's. But what i see is that it looks like they have it full screen? is this possible that it resizes to the screen inch that user has?

also if some 1 has some insperation links please send them

greets

[Logit]

.
Place this into a Regular Module, activated from the sheet with a command button. You will need a command button to show the menu bar again.

Please Login or Register  to view this content.

The attached example has left the ROW and COLUMN headings visible. If you hide them as well, first in the menu bar control for rows / columns / formula fields / grid lines, etc. then the screen will only show the cells and nothing else.

Beware .... you will always need a means of moving to another sheet - closing the workbook - if you implement this scenario. You certainly don't want your user to access the sheet with no menu and not be able to leave.

WARNING !!! When you disable the menu bar ... BEFORE CLOSING THE WORKBOOK BE CERTAIN TO RE-ENABLE THE MENU AGAIN. If you don't, all of the other workbooks you open after closing this workbook will not have a menu bar.


There are plenty of examples on the Forum and the 'Net. Search for HIDE MENU BAR or MINIMIZE MENU BAR.

[Lyncz92]

Hey Logit,

I am still very happy with the file you attached here months ago. Now i only have a qeustion is it also possible to make the windows taskbar disapear when i use hide_menu and make it visible again when run show_menu? basically wht i am searching for is to make it like Powerpoint when play the slides in fullscreen :D

greets, Lyncz

[Logit]

.
I tried to locate code to accomplish your goal. I do not currently have any code in my "tool box" that would do that.

The single code example I located will hide the taskbar but it doesn't make the taskbar re-appear. At least not on my
computer. If you want to try it on your computer the link is :

http://www.vbaexpress.com/kb/getarticle.php?kb_id=54

But keep in mind ... if it doesn't work on my computer ... how many other systems out there will it also fail ?

[Lyncz92]

Hey Logit.

I think i have used this code once before and it indeed made the taskbar disaprear but didn't come back . So you probably right that systems will fail and people will probably panic like i did hahah :P
However if you ever found a solution to this problem than please let me know :D

Greets, Lyncz