If you have a question, please send it to us.
1) Is it possible to have a worksheet called "History" ?
No. History is reserved word and cannot be used for the name of a worksheet.
2) Is it possible to prevent a user from adding or removing worksheets ?
Yes. Review > Protect Workbook > Protect Structure and Window.
3) 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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext