Hiding 'Options' in excel

[popper]

Hi

In Excel, I want to be able to hide the 'tools - options' area or prevent users from reaching there so that they cannot reveal row and column headers etc.

I tried protecting the workbook but this does not work. Any help would be appreciated.

Thanks

 

[combo]

Instead of workbook protect the sheet.
Restrictions in excel interface can cause problems. If you need limitations for specific workbook, this can be done by macro, that can be disabled by the user. On the other hand, general excel settings on a specific machine will apply to all documents here, but disappear in another computer.

combo

 

[lionelhill]

I'm just curious: what possible harm can a user commit by being allowed to see row and column headers?

 

[combo]

Good point lionelhill, I missed "headers" in question when writing my post.
Indeed, maybe someone will find another solution if we know the problem.

combo

 

[SkipVought]

BTW, anyone with some savy will know or can find the keyboard shortcuts for most toolbar button features.
[tt]
T O e
[tt]
to toggle row/column headers.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[popper]

The reason for my wanting to do this is that this is a turnkey application. The screen looks good, with no gridlines, row and column headers and no space taken for the formula bar. I also don't want any scrolling to be done. All of this can be changed by users who can then pass the application on to other users who will be presented with an application that looks different from its original design. It seems reasonable to disable these changes under password.

Thanks

 

[buitenhek]

popper,
A reasonable request to maintain aesthetics-yes I agree. I have been wrestling with this for many years.
However, Excel was designed to be flexible and open on the world stage. Security is only minimal on protecting cells, formulas and formats.
Design the page to fit the screen and do similar for the print then password protect the page and book. Let the user decide if they want to miss a portion because of size or column/row layout.


Regards
Peter Buitenhek
ProfitDeveloper.com

"Never settle for a job well done...always look for cost cutting measures