Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
Is there a VB code to turn on and off Full Sceen view?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
Simple:
Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
That is great, how can I make this Macro run automatically when the workbook
is opened up? "ryguy7272" wrote: Simple: Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
Just put the code in 'ThisWorkbook':
Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub If this post is helpful, please click 'Yes' Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: That is great, how can I make this Macro run automatically when the workbook is opened up? "ryguy7272" wrote: Simple: Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
Here is what I got and it doesn't go to full screen when I open it???
Sub Open_() ' ' Open_ Macro ' ' Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub "ryguy7272" wrote: Just put the code in 'ThisWorkbook': Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub If this post is helpful, please click 'Yes' Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: That is great, how can I make this Macro run automatically when the workbook is opened up? "ryguy7272" wrote: Simple: Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
Alt + F11
Put the code into ThisWorkbook Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub Save and Open HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Here is what I got and it doesn't go to full screen when I open it??? Sub Open_() ' ' Open_ Macro ' ' Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub "ryguy7272" wrote: Just put the code in 'ThisWorkbook': Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub If this post is helpful, please click 'Yes' Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: That is great, how can I make this Macro run automatically when the workbook is opened up? "ryguy7272" wrote: Simple: Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Full Screen
The code must reside in the ThisWorkbook module. It won't work if it resides in any other module. Also, the name of the procedure is "Workbook_Open", not "Open_". And, of course, it won't work in VBA procedures are disabled. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 12 Aug 2009 15:00:01 -0700, Masters wrote: Here is what I got and it doesn't go to full screen when I open it??? Sub Open_() ' ' Open_ Macro ' ' Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub "ryguy7272" wrote: Just put the code in 'ThisWorkbook': Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub If this post is helpful, please click 'Yes' Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: That is great, how can I make this Macro run automatically when the workbook is opened up? "ryguy7272" wrote: Simple: Sub FS() Application.DisplayFullScreen = True End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Masters" wrote: Is there a VB code to turn on and off Full Sceen view? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
full screen | New Users to Excel | |||
Full Screen | Excel Programming | |||
Macro to display full screen automatically | Excel Discussion (Misc queries) | |||
Veiw Full Screen | Excel Programming | |||
Resetting Screen to Full | Excel Programming |