Hide menu, disable editing, but enable filters

[hollynordenberg]

Hi -
I have an excel workbook that is connected to a DB2 table. I've set up the workbook to auto refresh when the workbook is opened, and auto filters are turned on. Now I want to disable any features and hide all the menus so that users that open this file cannot make any changes. I would prefer if the ribbon and all the tabs (Home, Insert, Page Layout, etc) were hidden from the user. If I protect the worksheet then the data does not refresh.

Anyone have any ideas?

Thanks,
Holly

 

[Deepak]

Hi,
Trigger the following

on open
Application.DisplayFormulaBar = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", False)"
on close
Application.DisplayFormulaBar = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", True)"

For worksheet protection,you need to read this.
http://msdn.microsoft.com/en-us/library/office/aa191957(v=office.10).aspx