Attach toolbar settings to particular Excel file?

**NewYears1978** · 03-17-2010, 04:48 PM

I'm wondering if there is a way to turn off options in the toolbar and layout such as hiding the Column lines, turning off certain bars, etc..and then have this attached to a certain workbook only..

So that when that workbook is open all of those toolbar settings are used, but then when other excel files are opened it reverts back to the default toolbars..

Thanks in advance.

**royUK** · 03-18-2010, 03:41 AM

There is,but it's not recommended because if Excel crashes then your user's settings willbe messed up. Result,one unhappy user

**NewYears1978** · 03-18-2010, 02:15 PM

What causes a crash?

Im the only one using the files..I just hate having to turn my toolbars on and off and change them based on what I am doing..but I guess it might be the best thing to do if it crashes.

**royUK** · 03-18-2010, 04:09 PM

Anything can cause a crash, I personally have my ToolBars set up as I want & maintain them that way.

What is you want to change?

Are you actually using Excel 2007? If you are then there are no Toolbars to alter. If not you've posted in the wrong Forum

**NewYears1978** · 03-23-2010, 02:22 PM

I might have been confusing with my question..and yes I am using Excel 2007

I'm referring to options such as turning off the gridlines, or hiding the toolbar altogether, etc.

Some documents I want some options to show.

To simplify just say I had two documents that I use, one I want gridlines the other I don't..is there a way to make each document save the settings I change (gridlines showing) in each..or is this cross all excel only.

This is a rather simple example but it better explains what I meant, I think.

**Andy Pope** · 03-24-2010, 06:24 AM

Depending on exactly what you want to do you maybe able to use vba code.

If you place this in your file it will turn gridlines off for that file.

Code:

Private Sub Workbook_Open()
    
    With Application.CommandBars
        If .GetPressedMso("ViewGridlinesToggleExcel") Then
            .ExecuteMso "ViewGridlinesToggleExcel"
        End If
    End With

End Sub

Or you may need to use Ribbonx xml to fully control the ribbon.