How to enable user functions?

Please Login or Register  to view this content.

using this code disables many functions that includes: font, size, fill in colour, comments etc. How can I enable these functions to work while still be able to use the code?

An attachment shows the situation as the functions are disabled with the code in effect.

All help will be greatly appreciated.

Look at Help for the Protect method. It has lots of arguments to set options.

Auto_Open is deprecated in favor of Workbook_Open in the ThisWorkbook module.