User FAQs


1) Is it possible to prevent a user from adding or removing worksheets ?
Yes. Review > Protect Workbook > Protect Structure and Window.


2) Is it possible to hide a worksheet so the user cannot unhide it ?
Yes. This can only be done via the Visual Basic Editor, Properties window.

Sheets(2).Visible = xlSheetVisibility.xlSheetVeryHidden 



© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext