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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

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