steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
I want to be able to configure Excel to display the data only. Here's what I have so far:
I had played with this years ago and from my files I have this code:
I didn't run that to produce my sample above (I'm trying to figure
out if that will lock me out and I can't get back in) I'm really rusty
at macros after all this time.
Anyway, I'd like to be able to remove all of it even the Microsoft Excel
logo at the top. Numbers down the side column letters, tabs etc. And a
button or keyboard command to restore Excel back to normal configuration.
Background: I'm making a video of a series of similar screens and
If I can do a clean screen shot for each frame in the video it won't jiggle.

I had played with this years ago and from my files I have this code:
Code:
Application.DisplayFullScreen = True
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Application.DisplayFormulaBar = False
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
ActiveSheet.DisplayPageBreaks = False
I didn't run that to produce my sample above (I'm trying to figure
out if that will lock me out and I can't get back in) I'm really rusty
at macros after all this time.

Anyway, I'd like to be able to remove all of it even the Microsoft Excel
logo at the top. Numbers down the side column letters, tabs etc. And a
button or keyboard command to restore Excel back to normal configuration.
Background: I'm making a video of a series of similar screens and
If I can do a clean screen shot for each frame in the video it won't jiggle.
Last edited: