pleased2help
New member
- Joined
- Jun 27, 2013
- Messages
- 28
- Reaction score
- 0
- Points
- 0
Hi All, Can you help please, I have taken out all the headings, ribbons, scroll bars etc to leave just the spread sheet (Read only) I use:-
Sub hide()
Sheet2.Visible = xlSheetHidden
Sheet3.Visible = xlSheetHidden
Sheet4.Visible = xlSheetHidden
Application.DisplayFormulaBar = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayOutline = False
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
ThisWorkbook.Save
End Sub
when on the screen it clears down the sheet and saves ( with no file tab ), HOWEVER, when i reopen the saved sheet the file tab comes back !!! so frustrating Can any one help? as i dont want any one to resave the sheet.
Many thanks in Anticipation
Sub hide()
Sheet2.Visible = xlSheetHidden
Sheet3.Visible = xlSheetHidden
Sheet4.Visible = xlSheetHidden
Application.DisplayFormulaBar = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayOutline = False
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
ThisWorkbook.Save
End Sub
when on the screen it clears down the sheet and saves ( with no file tab ), HOWEVER, when i reopen the saved sheet the file tab comes back !!! so frustrating Can any one help? as i dont want any one to resave the sheet.
Many thanks in Anticipation