PDA

View Full Version : Same concept hide and full screen



kamalmalek
01-09-2012, 07:19 PM
dears,
i have two questions in same concept:

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub is to let full screen but whenever double click on top excel the client can retrieve normal screen, how can i keep screen full and not responding to client??


Worksheets("Confidential").Visible=false to hide excel sheet but client can by selected unhide option to show sheet again, how can i keep sheet hide and not responding to client

thank you in advance.....

Kenneth Hobs
01-09-2012, 07:45 PM
For one part:
Worksheets("Confidential").Visible = xlVeryHidden