Dashboard and hiding Ribbon etc

[Graeme155]

I have written a few Dashboards and want to remove the 'extra' excel pieces. Have remove the Ribbon, Formula Bar, Headings, Message Bar and Gridlines - but these seem to only be removed on my computer.

Can anyone guide me on how to completely remove all the excel bits, including top and bottom bars?

Tar

 

[S M C]

Sub ToggleVisibility()
    
    Dim blnShow As Boolean
    blnShow = Application.DisplayFullScreen
    
    With Application
        .DisplayFullScreen = Not blnShow
        .DisplayStatusBar = blnShow
    End With
    
    With ActiveWindow
        .DisplayVerticalScrollBar = blnShow
        .DisplayHorizontalScrollBar = blnShow
        .DisplayWorkbookTabs = blnShow
        .DisplayRuler = blnShow
        .DisplayGridlines = blnShow
        .DisplayHeadings = blnShow
    End With
    
End Sub

 

[Graeme155]

Thanks but I assume this is a Macro? Just I haven't got as far as teaching myself Macros yet.

Might be the time to start - can you confirm how I insert this?

Graeme

 

[S M C]

In Excel, hit ALF+F11

This will take you to the Visual Basic Editor. In the VBE, open the project explorer (CTRL+R) if it is not already open. You would see a list of projects (pertaining to your workbook [or open workbooks]). Right-click on your workbook and insert a module. In the new module paste the above code.

There are various events that you can use to call this macro depending on how you want to use it. Let me know if that's the case.

But in case you want to test run this, close the VBE, and hit ALT+F8. You can see the name of the macro in the list. Select and Run.

 

[tusharm]

My advice to you would be...don't.

I've developed some fairly advanced solutions for some fairly sophisticated customers and I know one thing. I don't try and control their environment. Rather than fight them, work with with your customers and their respective environments.

I have written a few Dashboards and want to remove the 'extra' excel pieces. Have remove the Ribbon, Formula Bar, Headings, Message Bar and Gridlines - but these seem to only be removed on my computer.

Can anyone guide me on how to completely remove all the excel bits, including top and bottom bars?

Tar

 

[Graeme155]

I have a Dashboard that consists of two sheets. I have added a Hyperlink from each sheet to the other. So all the client has to do is view the sheet and close it, without saving.

Thus I do not have any need to bottom or top bars and feel it makes it more professional without these.

I hear what Tusham is saving but wouldn't it be possible to change global settings when opening and reseting them when closing ??

Graeme

 

[Dryver14]

If the dashboard is not interactive merely a presentation then why not present it on Powerpoint?

 

[Graeme155]

No it is Interactive. Can show the Sales by Individual Months.

Graeme