Removing a lot of stuff

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks, Bob. But what about the sheet tabs?

Bob Umlas said:
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
Click to expand...
 
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.)
 
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.
 
Back
Top