Removing a lot of stuff

[Guest]

Hello

I need a help. As I've developed a small system based on Excel, I'd like users not to be able to see any toolbars, menubar, and sheet tabs. The workbook and sheets are password protected, but they still can unhide tabs and bars. Is that possible.

Thanks

 

[Bob Umlas]

application.commandbars("Toolbar list").enabled = false
will prevent users from altering the display of any toolbars
turn it to true to get them back.

Bob Umlas
Excel MVP

 

[Guest]

Thanks, Bob. But what about the sheet tabs?

application.commandbars("Toolbar list").enabled = false
will prevent users from altering the display of any toolbars
turn it to true to get them back.

Bob Umlas
Excel MVP

 

[Dave Peterson]

Sometimes, it's quicker to just record a macro when you do it manually:

Tools|options|View tab|and uncheck the sheet tabs option.

I got this line in my recorded macro:

ActiveWindow.DisplayWorkbookTabs = False

(And I just used the option again to show the worksheet tabs.)

 

[Guest]

Thanks Dave. But what if I don't want that users turn that option back on again?

 

[Dave Peterson]

You'd have to stop them from using Tools|options.
You'd have to stop them from using code to show it.

It's not something I'd even bother with.

How about an alternative.
Hide the worksheets and protect the workbook--including the windows structure.

Then if you want the user to go to a different sheet, you provide a macro that
unprotects the workbook, unhides the other worksheet, hides the original, and
then reprotects the workbook.

That said, the workbook protection isn't very secure. There is code that's
posted almost everyday that can unprotect a workbook.