Display data field only

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:

2vd4h7k.jpg


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:

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
I solved this one by other means ie., I got my graphics program to cooperate (-;

Yes I did run my macro it did work (sort of)

Yes it did jam up the works requiring the Three Finger Salute.

Now all I have to do is stitch over 100 images together in to a video (-:

If you worked on this one - Thank you
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top