Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob


"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson

Dave,
As a second option, I guess I could do something like:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayHeadings = False
End Sub

Thanks again for all your help and advice.
Bob


"Dave Peterson" wrote:

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson

You could use that, but the user could disable macros or events or just change
the option.



Bob wrote:

Dave,
As a second option, I guess I could do something like:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayHeadings = False
End Sub

Thanks again for all your help and advice.
Bob

"Dave Peterson" wrote:

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

It might be a bit of overkill, but if you did the DisplayHeadings = False and
then
deleted the ToolsOptions from the menu, would it serve your purpose. Of
course, you would have to put it back at the end of the macro, because it
would otherwise carry over to any subsequent instance of Excel. But it would
make it difficult for a novice to restore the headings, since the check box
would be inaccessible untile the menu item was restored.

"Bob" wrote:

Dave,
As a second option, I guess I could do something like:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayHeadings = False
End Sub

Thanks again for all your help and advice.
Bob


"Dave Peterson" wrote:

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson

Basically, that's what Dave's code does. But he didn't mention restoring it
before closing the program.

"Bob" wrote:

Dave,
As a second option, I guess I could do something like:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayHeadings = False
End Sub

Thanks again for all your help and advice.
Bob


"Dave Peterson" wrote:

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson

Thanks for the suggestion. However, I would prefer to not mess with the menus.


"JLGWhiz" wrote:

Basically, that's what Dave's code does. But he didn't mention restoring it
before closing the program.

"Bob" wrote:

Dave,
As a second option, I guess I could do something like:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayHeadings = False
End Sub

Thanks again for all your help and advice.
Bob


"Dave Peterson" wrote:

Nope. I can't.

You don't have that kind of granular control over the dialogs in excel.

In my USA version of Excel, I could use a line like this:

With Application.CommandBars("worksheet menu bar").Controls("Tools")
'.enabled or .visible????
.Controls("Options...").Enabled = False
End With

to try to prevent users from clicking on Tools|Options...

But if they reset the toolbar or disabled macros, then it would not work very
well!

Bob wrote:

Dave,

What I want to do is click on the "Row and column headers" checkbox so that
the row and column headers are not displayed. Then I want to prevent users
from re-displaying the row and column headers (i.e., unchecking the checkbox).

Can you tell me how to disable the "Row and column headers" checkbox in VBA?

Thanks,
Bob

"Dave Peterson" wrote:

I don't think you can change any of those built-in dialogs.

You can disable them, but you can't change them.

Bob wrote:

Is there a way in VBA to disable the "Row and column headers" option within
the Tools | Options... | View tab menu so that a user cannot check (or
uncheck) the checkbox? I would like to do this without having to create a
custom toolbar or menu.

Thanks in advance for any guidance.

--

Dave Peterson


--

Dave Peterson