hello
i want to my workbook in full screen
no menu bar
no tools bar
no format bar
no formula bar
no Standard bar
no rows and column heading
thanx
i want to use as a macro do and undo
thanx
hello
i want to my workbook in full screen
no menu bar
no tools bar
no format bar
no formula bar
no Standard bar
no rows and column heading
thanx
i want to use as a macro do and undo
thanx
Hi,
would:
and:ActiveWindow.DisplayHeadings = False Application.DisplayFullScreen = True
be enough?ActiveWindow.DisplayHeadings = True Application.DisplayFullScreen = False
Regards
M
try below
Sub changein() Application.DisplayFormulaBar = False Application.DisplayFullScreen = True Application.DisplayScrollBars = False Application.DisplayStatusBar = False 'your code goes here Application.DisplayFormulaBar = True Application.DisplayFullScreen = True Application.DisplayScrollBars = True Application.DisplayStatusBar = True End Sub
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks