User FAQs

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 

4) Is it possible to replace asterisks (*) in your cells ?

5) What is the difference between the active worksheet and the current worksheet ?
The active worksheet is the sheet the user is currently looking at or has selected.
The current worksheet is the sheet that the code or function is running from.
They are often the same, but they can be different, especially when using automation.